Bubble - skipping data
 

Hi,

When I make a bubble chart, xls skips the unpair data ??

It takes only the 2nd - 4th - 6th - ... values.

Any idea what I do wrong ?

Rgds,
Fabian

Bubble - skipping data
 

On Mon, 5 Nov 2007, in microsoft.public.excel.charting,
Gecko said:

When I make a bubble chart, xls skips the unpair data ??

"Unpair"? Do you mean "odd" as opposed to "even"?

It takes only the 2nd - 4th - 6th - ... values.

It takes the 1st value as bubble X value (for all series), and the 2nd,
4th, and 6th values as bubble Y values. It is taking the 3rd, 5th, and
7th values as bubble *radius* values.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Bubble - skipping data
 

Hi Del,

when I have the following data:

22% - 0,04 - 12345
12% - 0,12 - 6543
15% - 0,07 - 7543
18% - 0,02 - 8543

It only puts the 12% and 18% data into the chart.

22% and 15% are just 'forgotten' ...

Rgds,
F



"Del Cotter" wrote:

On Mon, 5 Nov 2007, in microsoft.public.excel.charting,
Gecko said:

When I make a bubble chart, xls skips the unpair data ??

"Unpair"? Do you mean "odd" as opposed to "even"?

It takes only the 2nd - 4th - 6th - ... values.

It takes the 1st value as bubble X value (for all series), and the 2nd,
4th, and 6th values as bubble Y values. It is taking the 3rd, 5th, and
7th values as bubble *radius* values.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Bubble - skipping data
 

On Mon, 5 Nov 2007, in microsoft.public.excel.charting,
Gecko said:
when I have the following data:

22% - 0,04 - 12345
12% - 0,12 - 6543
15% - 0,07 - 7543
18% - 0,02 - 8543

It only puts the 12% and 18% data into the chart.

It's reading rows instead of columns. When you run the Chart Wizard, be
sure to choose "Series in... Columns" for the data.

Alternatively, place text labels in the cells above "0,04" and "12345",
and select the range including the labels and the blank cell above
"22%", to give the wizard the clue.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Bubble - skipping data
 

Unfortunately this still doesn't work.

Thanks anyway !

"Del Cotter" wrote:

On Mon, 5 Nov 2007, in microsoft.public.excel.charting,
Gecko said:
when I have the following data:

22% - 0,04 - 12345
12% - 0,12 - 6543
15% - 0,07 - 7543
18% - 0,02 - 8543

It only puts the 12% and 18% data into the chart.

It's reading rows instead of columns. When you run the Chart Wizard, be
sure to choose "Series in... Columns" for the data.

Alternatively, place text labels in the cells above "0,04" and "12345",
and select the range including the labels and the blank cell above
"22%", to give the wizard the clue.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.