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: 51
Default very odd bubble chart problem

Weird bubble chart problem:

Using excel 007, I'm having trouble with what used to be the chart
wizard when I try to create a bubble chart.

I've set it up with X, Y, and Z columns and 50 (state) data points
with variable labels in the first row.

When I highlight all that and insert a bubble chart it does not seem
to recognize that the first row are the series names. The data
selection shows no series name and the data ranges start with the
label cells.

Oddly, it works fine if I only highlight 14 rows (13 states).
Anything more and it goes bust.
Indiana messes me up everytime. I've checked for non-numeric data
cells, there are none.

I can do it with 13 datapoints and then stretch the matrix down to
make it work.

But it's not supposed to work like that. If I were a Canadian, I
wouldn't complain....

Gary Klass
 
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
Excel 'bubble' chart where colors are used instead of bubble size paulmichael Charts and Charting in Excel 3 December 5th 07 03:33 PM
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
Problem with BUBBLE CHART scale and legend keesberbee Charts and Charting in Excel 6 July 2nd 06 09:11 PM
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 07:16 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"