LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 32
Default Bubble chart basics

Using 2000 I am trying to come up with a meaningful sample of a bubble chart
for the charting class I teach and I'm having a really tough time. I know
nothing of bubble charts. I have been searching the group and web for some
time now trying to figure out where I'm going wrong.

Here's my data:

Region Avg Stay Patients
North 1.8 1208
East 2.3 2304
South 1.1 961
West 3.4 1936

Here's what I want to get when I use the bubble chart - the region names as
the X axis values, the average stay as the y axis and the bubble size
indicating the number of patients.

What I GET is the numbers 1 through 6 as the X axis values instead of the
region names. The size of the bubbles is correct as is the Y axis - just the
bottom axis is not what I expect.

If I put the data label values on the series I get the region names - but
I'm thinking they should be part of the bottom axis.

Where am I going wrong??

Lauri S.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I change the color of negative bubble in bubble chart Jon Peltier Charts and Charting in Excel 0 July 4th 07 03:29 PM
How can I change the color of negative bubble in bubble chart Daniel Charts and Charting in Excel 1 July 4th 07 03:25 PM
How do I link a bubble in the bubble graph to another chart? Pradnya Purandare Charts and Charting in Excel 2 July 17th 06 05:21 AM
ho to change in the bubble chart the bubble position and size laszlo Charts and Charting in Excel 0 March 25th 05 04:45 PM
How do I move a hidden bubble to the front in a bubble chart in E. Scott Excel Discussion (Misc queries) 0 February 20th 05 07:55 PM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"