Line chart with Bubble data points

  • Thread starter Thread starter DaSkiDude
  • Start date Start date
D

DaSkiDude

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
 
Back
Top