Conditional Formatting of a scatter graph

ezpete

New Member
Joined
Sep 13, 2014
Messages
16
Hi All,

Thanks for checking this post, and thank you even more if you can help!

I've had a search and found nothing the same as what i need to know, apologies if this has already been asked.

I'm seriously stuck and in need of help,

I need to plot a heatmap of data based on geographical location, this needs to be done in Excel only, as it is to be a shared document.

I have my location coordinates set up to graph out the XY to the right scale perfectly, however, i need to add another variable into the mix, quantity.
I would like to format the markers to change colour from a scale of highest to lowest, failing that then the alternative is to change the marker size.

I have seen a 3D scatter graph, however this is unsuitable as it will hide a significant amount of data as the columns grow.

Any help with this would be massively appreciated.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
.
.

Perhaps a bubble chart might a suitable for this problem. It is like a scatter chart, but you can vary the size and colour of the markers (bubbles) point by point...
 
Upvote 0
Thanks for the suggestion, however it would appear that I have too much data for a bubble chart.
any other suggestions?
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top