Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Help with a Bubble Chart in Excel 2010

Posted on 2014-02-20
6
Medium Priority
?
377 Views
Last Modified: 2014-02-20
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
Comment
Question by:broadcastwarehouse
  • 3
  • 2
6 Comments
 
LVL 53

Expert Comment

by:Rgonzo1971
ID: 39873145
First question

What are you trying to say with the chart?

Regards
0
 
LVL 6

Expert Comment

by:Jaffa0
ID: 39873161
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
 

Author Comment

by:broadcastwarehouse
ID: 39873194
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 53

Expert Comment

by:Rgonzo1971
ID: 39873214
Hi,

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

Regards
Copy-of-Example-for-Bubble-Chart.xlsx
0
 

Author Comment

by:broadcastwarehouse
ID: 39873224
So it isn't possible with a bubble chart?
0
 
LVL 53

Accepted Solution

by:
Rgonzo1971 earned 1200 total points
ID: 39873242
It just does not have any meaning

Regards

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question