Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Category axis in bubble chart
Hi,
I would like to draw a bubble chart with category axis eg. with following data: mon sun 5 mon rain 4 tue sun 1 tue cloudy 2 tue rain 7 wed sun 3 wed rain 8 wed cloudy 4 So on the x-axis I would like to see the labels mon, tue, wed; on the y-axis sun, cloudy, rain and the size of the bubbles is given by the numbers. Is this possible in Excel XP and how to proceed? Thx for your attention, Eric ---------------------------------------- Mijn Postvak In wordt beschermd door SPAMfighter 14511 spam-mails zijn er tot op heden geblokkeerd. Download de gratis www.SPAMfighter.com vandaag nog! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Category axis in bubble chart
Replace the weather adjectives by numerical values (1=snow, 2=rain,
3=cloudy, 4=sunny), and plot these values. Hide the "normal" axis labels, and place textboxes along the axis with these labels. Normally I propose a combination chart, such as this: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html but a bubble chart doesn't do combos. However, you could add a bubble series along the Y axis, then hide the bubbles (no border, no fill), as in the above example. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Eric27" wrote in message ... Hi, I would like to draw a bubble chart with category axis eg. with following data: mon sun 5 mon rain 4 tue sun 1 tue cloudy 2 tue rain 7 wed sun 3 wed rain 8 wed cloudy 4 So on the x-axis I would like to see the labels mon, tue, wed; on the y-axis sun, cloudy, rain and the size of the bubbles is given by the numbers. Is this possible in Excel XP and how to proceed? Thx for your attention, Eric ---------------------------------------- Mijn Postvak In wordt beschermd door SPAMfighter 14511 spam-mails zijn er tot op heden geblokkeerd. Download de gratis www.SPAMfighter.com vandaag nog! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Bar Chart Category Axis Problem | Charts and Charting in Excel | |||
Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel |