How do I create an area and line combination chart?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
How to create combination stacked area and line chart? 2
Access Combination Chart Types Access 2010 0
Create 2-Axis Combination Chart XL 2007 2
How do you create combination charts (line-coulmn) in excel 2007? 1
How do I create a line-area combination chart in Excel? 1
Data Series Labels in Area Chart 3
Combination charts 1

Top