Bubble - skipping data

[Gecko]

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

 

[Del Cotter]

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.

 

[Gecko]

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]

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.

 

[Gecko]

Unfortunately this still doesn't work.

Thanks anyway !