How do I create an area and line combination chart?

N

Nuala

I want tocreate a combination chart, using the chart types area and line, it
is not listed as a custom type in Excel - is it possible?
 
A

Andy Pope

Hi,

Ignore the built-in combinations and create your own.
Start with creating a Line chart with your data. Then select the line
series that you want as an area chart. Right click and pick Chart Type
to select the required Area chart type.

Cheers
Andy
 
Top