Scatter plot with colours showing the density of dots in all areas

[Ejje]

Hello,

I tried to find some info about this using a web search but didn't know what words to use. I would like to make a scatter plot that in some way change the colors of the dots depending on how many dots is in that area of the scatter diagram. The amount of dots per area unit so to say. The reason that I would like to have this is that I would like it to be more visible how likely it is that dots would appear in the area.

What is needed to achieve this? Does anyone have a clue, code or something like that.

Thanks

[MrShorty]

Sounds like a "conditional formatting for charts" kind of problem -- which, interestingly, is mostly a spreadsheet question (since one cannot apply conditional formatting directly to a chart).

I would suggest you start with this tutorial: http://peltiertech.com/conditional-f...-excel-charts/

The overall approach I see to this:

1) Compute density around each point, or compute density for different regions of the chart, or whatever you want to do to compute density. I see no indication in your post how you would like to compute density -- perhaps you do not have an idea, yet, either. In many ways, this is probably the hardest part of the question (especially if you do not, yet, have an idea how you want to compute density).
2) Set up helper columns with the IF() functions that will choose which column each data point should be in.
3) Build scatter chart with those helper columns, then format each data series as desired.

Do you have a sample workbook you can upload to the forum? What kind of algorithm do you want to use to compute density?