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?
daniellej2015Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

by definition, a bubble chart is a scatter chart, i.e. both axes are numeric. If you want the axis labels to show text instead of the axis value numbers, you need to place dummy series accordingly and use data labels.

Currently there is no simpler approach.

Don't shoot the messenger.

If you need more guidance, please post a file. It does not have to be your original file, but it should have the same data structure and a chart in place.

cheers, teylyn
0
Christopher Jay WolffWiggle My Legs, OwnerCommented:
Hi.

You may have to convert your data somewhere on the sheet in new columns or rows to something more useful to producing the bubble chart you desire.

I threw a sample sheet together here and it is attached.

After inserting chart, I right-clicked on the chart, chose "Select Data", and you get the following dialogue.

Excel 2013 dialogue for selecting data on Bubble Chart.
Then when you click the Edit button, you get the next dialogue,

Excel 2013 Edit Series dialogue for Buibble Chart.
When you use the selection tools circled in blue for your x and y data, your cursor will change to thick cross to select data by dragging a box.  I dragged the dates column and for the other axis dragged the category one numbers.

I would then insert another chart and drag the date column and the category 2 numbers.  Then you have two charts.  But you see how it goes and maybe you can manipulate your data into tidy columns or rows to produce one chart.

Difficult to say without knowing more about your data.
EEBubbleExcel.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
daniellej2015Author Commented:
thanks for the responses  what is the dummy series? How would I go about doing so?
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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.
0
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.