Line Chart inside/on an Area Chart

[3G]

Hi there-

I have a few series that I've got on an area chart. Now, I'd like to overlay a line onto that chart. I've seen the "cooking delicious charts" lesson, but the example doesn't really explain how to merge the two chart types? Is it nothing more than overlaying (manually) one on top of the other?


Thanks

3G

 

[Hui]

Add all the series to the same chart as an area chart

Select the series you want as a line chart

Right Click and Change Series Chart Type, Select Line Chart

You can also Shift it to the secondary Y axis if required

 

[3G]

Sometimes the easiest things are just easy!