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

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.

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.

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.

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.