How to change x-axis of bubble chart to non-numeric values?

**Exxel** · 07-01-2010, 01:49 PM

Hello,

I am trying to change the x-axis of my bubble chart to non-numeric values - File is attached for your reference.

How do I do this? I use Excel 2007 and have tried all options but to no avail. I am basically trying to replace the 1,2,3 etc (default values) on the x-axis of the bubble chart with say (Apple, HP, Samsung, Intel etc).

Please help.

Thanks....

**luv2glyd** · 07-01-2010, 02:14 PM

Can you post your spreadsheet?

**Exxel** · 07-01-2010, 07:14 PM

Here's the spreadsheet.

**Andy Pope** · 07-02-2010, 05:05 AM

Add another series and link the data labels to the text in order to mimic a text axis.

Use this free addin to do the linking of cells to data
http://www.appspro.com/Utilities/ChartLabeler.htm

**Andy Pope** · 07-02-2010, 05:32 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

**Exxel** · 07-13-2010, 06:09 PM

Hi Andy,

Thank you very much for your assistance. I did not realize that it's against the BB rules to post in multipe forums. I'll avoid this in future.

That said, your solution has worked well. One follow up question I do have is 'how did you link the text (of cell phone companies) in Column K to the chart? I have not been able to replicate that aspect. For eg, if I change 'Apple' in cell $K$3 to say 'Intel', that change is reflected on the chart. When I try to do this in a same chart that I have created - it does not work. I have to use text labels, which is not dynamic - meaning I have to manually change 'Apple' to 'Intel'. Is there some step that I am missing?

Thanks much in advance.

Regards,
-Laxman

**Andy Pope** · 07-14-2010, 06:42 AM

Have you tried the addin I suggested?

**ganeshexcel12345** · 10-15-2012, 01:58 PM

Can we do it without using add-id?

**ronpj678** · 05-11-2020, 01:55 PM

Hello All,

Can you please help in creating a bubble chart for the data shared. The bubble size should be as per the number of deals. X-Y axes should be the deal range and Years (2015 & 2019) Finding it difficult as both the axes are non-numeric.

Thanks in advance!

Deal Value 2015 (Number of Deals) 2019 (Number of Deals)
1-5 Mn 17 19
6-25 Mn 12 9
26 - 50 Mn 11 23
51-75 Mn 13 25
75-100 Mn 24 38

**FDibbins** · 05-11-2020, 01:57 PM

Originally Posted by ronpj678

Hello All,

Can you please help in creating a bubble chart for the data shared. The bubble size should be as per the number of deals. X-Y axes should be the deal range and Years (2015 & 2019) Finding it difficult as both the axes are non-numeric.

Thanks in advance!

Deal Value 2015 (Number of Deals) 2019 (Number of Deals)
1-5 Mn 17 19
6-25 Mn 12 9
26 - 50 Mn 11 23
51-75 Mn 13 25
75-100 Mn 24 38

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Also, it is almost always better if you can upload a sample workbook, showing what you have and what you want. See yellow banner at the top for details