Bubble Charts - Different Shapes


S

soroosj

Does anyone know if the bubble chart default shape of circle can be
modified to other shapes (i.e. triangle, square)?

The flexibility to present different shapes could be useful when
presenting two series on the same chart. For example, one series could
be the default circle, another a triangle.

I have seen this capability in other applications with advanced
charting capabilities.

I am using Excel 2003.

Regards,
Joel
 
Ad

Advertisements

A

Andy Pope

Hi,

Yes you can change the shape. To do so you need to use a custom marker.
Create a shape using the autoshapes menu. Format the shape in terms of
colour and border. Copy the shape using CTRL+C. Select the data series
in the bubble chart you want to change. CTRL+V to paste the shape.

Here is an explanation using pie charts as the custom marker but you
should get the idea.
http://www.andypope.info/charts/piedatamarkers.htm

Cheers
Andy
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top