View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default 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.