A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

very odd bubble chart problem



 
 
Thread Tools Display Modes
  #1  
Old October 1st, 2009, 10:11 PM posted to microsoft.public.excel.charting
Gklass
external usenet poster
 
Posts: 58
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
  #2  
Old October 1st, 2009, 10:49 PM posted to microsoft.public.excel.charting
Gklass
external usenet poster
 
Posts: 58
Default very odd bubble chart problem

I've tested this on another computer with the same data and get the
same problem.

With different data, it works up until 21 states.

  #3  
Old October 2nd, 2009, 08:16 PM posted to microsoft.public.excel.charting
Mike Middleton[_2_]
external usenet poster
 
Posts: 90
Default very odd bubble chart problem

Gary Klass -

Please verify that you are using Excel 2007 SP2.

I select a 3 column by 50 row range of numerical data and insert a bubble
chart. The chart has a single data series (with three values for each data
point). Initially there is no series name, but I can select the data series
by clicking a point on the chart and then edit the =SERIES in the formula
bar to add a series name if I wish. Although I have x,y,z labels above each
column of data, those cells are not included in the data series range. So, I
don't observe any misbehavior using Excel 2007 SP2.

- Mike
http://www.MikeMiddleton.com


"Gklass" wrote in message
...
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


  #4  
Old October 7th, 2009, 09:27 PM posted to microsoft.public.excel.charting
Gklass
external usenet poster
 
Posts: 58
Default very odd bubble chart problem

Yours work a bit better than mine,
but still, it's not supposed to work like that:


Try selecting just 9 rows and you may see how it is supposed to work



On Oct 2, 2:16*pm, "Mike Middleton"
wrote:
Gary Klass *-

Please verify that you are using Excel 2007 SP2.

I select a 3 column by 50 row range of numerical data and insert a bubble
chart. The chart has a single data series (with three values for each data
point). Initially there is no series name, but I can select the data series
by clicking a point on the chart and then edit the =SERIES in the formula
bar to add a series name if I wish. Although I have x,y,z labels above each
column of data, those cells are not included in the data series range. So, I
don't observe any misbehavior using Excel 2007 SP2.

- *Mikehttp://www.MikeMiddleton.com

"Gklass" wrote in message

...

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
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.