Does anyone know how to create a hybrid area-line chart in Excel?

Question

I am trying to create an area chart that has another data series in a line along the same x- and y-axes. I know you can add a trendline, but this only gives an approximation of the actual line which I wish to superimpose on the area chart. Any ideas?

Answer 1

-Chart all the data series as an Area chart.
-Right-click on the data series you wish to change
-Select Chart type...
-Select Line
-Click OK