Line chart with markers from separate dataset

[alexisremen]

Hi,

See attached example chart. I have a simple table. Header row + 5 data rows and 3 columns. First column is time, the other two are data. What I would like to do is plot the middle column in a line chart (easy), but then add the last column as circles to that line chart, preferably with a data label indicating the value and the size of the circle should increase with the value as well.

Is this possible?

Thanks!

 

[alexisremen]

(just to be clear, in the picture the line was made with Excel, but the circles and labels I drew in with Paint)

 

[Domenic]

Have a look at the following link...

Excel Scatter Bubble Chart Using VBA - Peltier Tech

Combination charts cannot be made with bubble charts in Excel, but you can use a scatter chart with variable size markers, and VBA makes it simple.

peltiertech.com

Hope this helps!