Excel 'bubble' chart where colors are used instead of bubble size

[paulmichael]

I am trying to create plots from 3-D data where the first two columns
determine the X & Y coordinate of the plotted symbol and the third column (Z)
gives the value which is represented by the color of the symbol. This is very
similar to the bubble plot where the size of the bubble represents the value,
however I cannot find any plot type in the menue which uses colors instead.
Is there a way to create a custom plot type to achieve this goal?

 

[Jon Peltier]

It's not built in, but it's also not hard to build. I assume you have a
discrete number of colors, and aren't trying to gradually change color with
value (which is known not to be an effective way to display variable data).
You could construct a conditional chart:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon

 

[Anders Løken]

Hi, and thanks for this post. Very helpful. I have one question however: When
I create a conditional bubble chart the bubbles still have different sizes.
To solve this i used a scatter chart instead. This works fine, but it doesnt
look as good is I want it to. I want the color of adjacent data points to
smoothly overlap. Is there any way to do this? I guess I could make the
markers really large? How about manipulating the data before making a chart?
(Interpolating between data points)