how do I create a bar graph with a trend line?

Hey guys,

I'm not sure whether this question has already been asked (if so, do excuse me and direct me to the answers).

But I intent to do the following (a bar chart with a line chart - integrated)

line and bar method.jpg

How do I go about doing it?

Appreciate your response.

You need to have a secondary axis

This link might help
http://office.microsoft.com/en-us/ex...001234165.aspx

Originally Posted by belle08

You need to have a secondary axis

This link might help
http://office.microsoft.com/en-us/ex...001234165.aspx

Thank you so much, Bella!

Originally Posted by belle08

You need to have a secondary axis

This link might help
http://office.microsoft.com/en-us/ex...001234165.aspx

sorry bella, but I have another question.

secondary axis disabled.jpg

How do I 'enable' the secondary axis plot? It seems to be 'locked' for some reason.

hi! not sure if you were able to figure this out. but what kind of graph are you using? secondary axis only works on 2d graphs. i think it's disabled on 3d graphs