Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bubble Charts - Different Shapes
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 |
#2
|
|||
|
|||
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 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
More on custom markers:
http://peltiertech.com/Excel/ChartsH...omMarkers.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Andy Pope wrote: 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 wrote: 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 |
#4
|
|||
|
|||
Thanks! This works perfectly. I did not think possible.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
How do I move a hidden bubble to the front in a bubble chart in E. | Excel Discussion (Misc queries) |