Bubble - skipping data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
When I make a bubble chart, xls skips the unpair data ??
Click to expand...

"Unpair"? Do you mean "odd" as opposed to "even"?
It takes only the 2nd - 4th - 6th - ... values.
Click to expand...

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.
 
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
 
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.
Click to expand...

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.
 
Back
Top