I have to create a chart in excel that shows the performance of a
stock over a year then I need to add in bubble data points on top of
that to show individual trades with the area showing the size of the
transaction.

Anyone have any ideas?


Thanks.

Hi,

Unfortunately bubble charts do not allow lines to connect the bubbles or for
the chart to be part of a combination chart.

You could use a xy-scatter and then some code to adjust the marker size.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
wrote in message
...
I have to create a chart in excel that shows the performance of a
stock over a year then I need to add in bubble data points on top of
that to show individual trades with the area showing the size of the
transaction.

Anyone have any ideas?


Thanks.