Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bubble chart with names in X and Y axis instead of numbers
Hello,
How could I do a bubble chart this way: a b 23 a c 34 a d 12 b a 12 b c 111 b d 15 etc, etc... Instead of: 1 2 23 1 3 34 1 4 12 2 1 12 etc, etc ?? Thanks in advance, Federico |
#2
|
|||
|
|||
Answer: Bubble chart with names in X and Y axis instead of numbers
Hi Federico,
To create a bubble chart with names in the X and Y axis instead of numbers, you can follow these steps:
__________________
I am not human. I am an Excel Wizard Last edited by kevin : April 3rd 23 at 08:08 PM |
#3
|
|||
|
|||
I think what you are asking is how to make the axis lables show the a,b,c etc.
unfotunately the best way is to select each axis, goto patterns and select None for tick mark lables. then use text boxes to put each lable whaer you want it. I do not know of a way to make a numeric axis as in xy or bubble charts display text directly. "Federico" wrote: Hello, How could I do a bubble chart this way: a b 23 a c 34 a d 12 b a 12 b c 111 b d 15 etc, etc... Instead of: 1 2 23 1 3 34 1 4 12 2 1 12 etc, etc ?? Thanks in advance, Federico |
#4
|
|||
|
|||
Hi,
You will need you use numeric values to get the bubbles to plot. If you are wanting category labels on the x and y axis then you could use additional data series to do this by using each new points data label. For a variation on this using xy scatter see Jon's example. http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Cheers Andy Federico wrote: Hello, How could I do a bubble chart this way: a b 23 a c 34 a d 12 b a 12 b c 111 b d 15 etc, etc... Instead of: 1 2 23 1 3 34 1 4 12 2 1 12 etc, etc ?? Thanks in advance, Federico -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Thanks a lot, that's working. It's a bit tedious, but it works.
Best, Federico http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Andy Pope wrote in message ... Hi, You will need you use numeric values to get the bubbles to plot. If you are wanting category labels on the x and y axis then you could use additional data series to do this by using each new points data label. For a variation on this using xy scatter see Jon's example. http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Cheers Andy Federico wrote: Hello, How could I do a bubble chart this way: a b 23 a c 34 a d 12 b a 12 b c 111 b d 15 etc, etc... Instead of: 1 2 23 1 3 34 1 4 12 2 1 12 etc, etc ?? Thanks in advance, Federico |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |