• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

Help with a Bubble Chart in Excel 2010

Is it possible to get a bubble chart from the attached information?

I have tried so many times, but I can't seem to make it work. All of the examples and notes from Google etc haven;t helped! They all seem to have three sets of data, but 2 of which need to be numbers/values - is this correct, or can you do it with the sort of info I am using?

Many thanks.
Example-for-Bubble-Chart.xlsx
0
broadcastwarehouse
Asked:
broadcastwarehouse
  • 3
  • 2
1 Solution
 
Rgonzo1971Commented:
First question

What are you trying to say with the chart?

Regards
0
 
Jaffa0Commented:
I think a bubble chart requires two numerical values, one for the size and one for the Y axis. I guess you were trying to get an evenly sized grid with bubbles in to represent the amounts? You may be better off with a different type of chart to represent your data.
0
 
broadcastwarehouseAuthor Commented:
I'm not too sure, my boss has asked me to do it!!

Column A are sweets, which we send to Customers, Row 1.

We want to see the values of how many sweets we send to each customer.

Does that make sense?!
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Rgonzo1971Commented:
Hi,

From your description a bar chart or a column chart makes more sense

Regards
Copy-of-Example-for-Bubble-Chart.xlsx
0
 
broadcastwarehouseAuthor Commented:
So it isn't possible with a bubble chart?
0
 
Rgonzo1971Commented:
It just does not have any meaning

Regards

See both sheets in example
Copy-of-Example-for-Bubble-Chart.xlsx
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now