Link to home
Start Free TrialLog in
Avatar of daniellej2015
daniellej2015

asked on

How do I substitute category for number in a bubble chart in Excel

I have a bubble chart, and on both  the x and y axis number are being shown. Instead of the number showing how to I manipulate the charts to show categories instead? Unfortunately the file cannot be uploaded and my team is persist on using this method. I know as a last resort I could just create labels over the numbers but in the long run this template I am creating will be automatic and therefore I would prefer a more simpler approach.  How do I substitute the numbers for categories in the bubble chart?
SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daniellej2015
daniellej2015

ASKER

thanks for the responses  what is the dummy series? How would I go about doing so?
Ah, with a bubble chart this is not as easy as I thought.  

Normally, I would put another data series into the chart, with Y values all 0 and X values as I need them. Then add data labels below the data points and change the label to use text from a cell. Then hide data markers and hide the X axis labels.

Alas, with bubble charts, data labels can only be placed inside the bubble, so they would sit right on the X axis line. In that case would normally use another chart type on the secondary axis.

Alas 2, a bubble chart cannot be combined with another chart.

So, tedious as it may be, using two charts, one overlaying the other, might be your best option.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.