Bubble charts

[JRCBoston]

Hi-

I am creating a bubble chart and was wondering if there is a way to color code the bubbles so that all bubbles with the same size are the same color. For instance, all size 1's are red, all size 2's are blue, etc.

Thank you.

 

[Derek Brown]

Have a look at Andy's reply at:
http://www.ozgrid.com/forum/showthread.php?t=87636&page=1
I have not yet looked at it in detail myself but it may help.

Other good sources for Chart Techniques etc. are:
http://peltiertech.com/Excel/Charts/ChartIndex.html
http://www.exceluser.com/catalog2/addins/kyd-sa.htm

 

[Steve=True]

Creating multiple colors usually involves creating a new data range for your chart that looks at the original data and creates individual series for each group by the color you want. Then after you create your chart you will need to change each series to the color that you want.

In this case you want size to have a unique color.

Easiest way is to group each size next to eachother and graph them as a series, then the next group and so on. Then each series will have a different color based on the groupings of size.

You can do this programitically by creating dummy series for your graph that finds all size 1 data points and adds them to the series, if it is a different size you will put an NA() in the if formula so that the chart will ignore this data point for this series and will only show your size 1's.

dummy series size 1 might look like this:

=if(original data series size=1, original data point, NA())

dummy series size 2:

=if(original data series size=2, original data point, NA())

This is how you make any chart change colors for different values like over budget = Red, under budget = Green.