View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Ed Ferrero Ed Ferrero is offline
external usenet poster
 
Posts: 115
Default Bubble Charts w/ Scatter Plot overlay

Hi Tim,

You can emulate a bubble chart with a scatter chart. Just need to paste some
circle shapes as markers for one scatter chart series. Then add a new series
and leave the markers as default.

A sample that you can change is here http://www.edferrero.com/charting.aspx
look for 'BCG Matrix'

Don't know how comfortable you are with VBA. If it gets too confusing, post
back and I will try to explain further.

Ed Ferrero

Is there a way to overlay a scatter plot chart on the same graph as a
bubble
chart? I'm currently using Excel 2002 and I can't get it to combine ANY
other chart type with a bubble chart. Will Excel 2007 allow me to do
this?