how do i control bubble size for each data series in excel 2007?

[Dave]

I'm trying to plot two bubble series with the same x and y values and then
use transparency so I can see both bubbles. I need to use different bubble
size scale factors since the data ranges of one series is 0 to 100 and the
range of the other is 0 to 10,000. I suppose I could take the log of each to
compress the range but I would rather be able to control the bubble size of
each series independently.

Thanks.

 

[Andy Pope]

Hi,

Looks like a bug. In xl2003 you would have had to move 1 of the series
to the secondary axis in order for the bubble scaling to have been
different. In xl2007 it would appear the size is deteremined by the min
and max value from all series.

Cheers
Andy

 

[Dave]

Bummer. I did try to put the second data series on the second axis but as
you noted that does not work in excel 2007. I did try taking the log of the
larger series but it compressed the range too much so it was hard to see the
difference.

Thanks for looking at it.

-- Dave