Bar Chart with Line graph

[a-man]

Hi,

I am trying to fit a line graph which connects all the end points of my bar chart (Not the high-low line function embedded within excel). Please see attached.


Example_BarChart.xlsx

Can you please assist?

Regards
A

[lecxe]

Hi

The end point of each bar in your chart corresponds to the sum of the values of all the years for the corresponding product.

You can add a column to your table, where you calculate the sum of the values of all the years and then add a scatter series using those values.

Jon Peltier explains here how to produce a bar-line combination chart.

http://peltiertech.com/Excel/Charts/BarLineCombo.html

I did a quick test with your chart.

[a-man]

Thank you!

[lecxe]

You are welcome. Thanks for the feedback.