bubble charts

[josie]

I've solved the macro question, but got another one.

When using a bubble chart, I find it hard to understand
how the 'third value' you're asked to specify actually
relates to the size of the bubble marker.

Is there a better chart type to use if the radius of the
bubble is actually an important variable?

 

[Tushar Mehta]

Create the bubble chart. Then, in the chart, double-click the plotted
series. In the resulting dialog box, from the Options tab, in the
'Size represents' frame, select the appropriate option.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[josie]

Thanks so much!

-----Original Message-----
Create the bubble chart. Then, in the chart, double- click the plotted
series. In the resulting dialog box, from the Options tab, in the
'Size represents' frame, select the appropriate option.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions


.

 

[Tushar Mehta]

You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Thanks so much!

{snip}