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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
Back
Top