Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble Charts
Hi,
I have been trying to display three ranges on a bubble chart - cost, benefit and ease. Ease I have three categories, easy, av, difficult which I have respresented by a number 1,2,3 to produce the chart. The chart is showing the ease category a different bubble sizes but to make it cleaer I would like it to be three different colours as well. Is this possible? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble Charts
The easiest way would be to have three series, one for each category. Set up
your data as X, Y, bubble size as before. Then add three columns, one per category, and only fill in the bubble sizes for each specific category, otherwise leave it blank. Make a bubble chart with the first three columns. Right click the chart, select Source data, click on the Series tab. Select the series, change the bubble size to the first category's column. Add a series, use the same X and Y but the second category for bubble sizes. Add another series, use the same X and Y and the third category's bubble sizes. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "LiAD" wrote in message ... Hi, I have been trying to display three ranges on a bubble chart - cost, benefit and ease. Ease I have three categories, easy, av, difficult which I have respresented by a number 1,2,3 to produce the chart. The chart is showing the ease category a different bubble sizes but to make it cleaer I would like it to be three different colours as well. Is this possible? Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble Charts
Thanks,
Asimpler way of doing it than formatting ways. Thanks again for your help (hope your computer survived this one this time!) LD "Jon Peltier" wrote: The easiest way would be to have three series, one for each category. Set up your data as X, Y, bubble size as before. Then add three columns, one per category, and only fill in the bubble sizes for each specific category, otherwise leave it blank. Make a bubble chart with the first three columns. Right click the chart, select Source data, click on the Series tab. Select the series, change the bubble size to the first category's column. Add a series, use the same X and Y but the second category for bubble sizes. Add another series, use the same X and Y and the third category's bubble sizes. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "LiAD" wrote in message ... Hi, I have been trying to display three ranges on a bubble chart - cost, benefit and ease. Ease I have three categories, easy, av, difficult which I have respresented by a number 1,2,3 to produce the chart. The chart is showing the ease category a different bubble sizes but to make it cleaer I would like it to be three different colours as well. Is this possible? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bubble Charts | Excel Discussion (Misc queries) | |||
Bubble Charts | Charts and Charting in Excel | |||
Bubble Charts | Charts and Charting in Excel | |||
Bubble charts | Charts and Charting in Excel | |||
labels for bubble charts | Charts and Charting in Excel |