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
 

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

Filtered view of Visio Chart 0
How to create a bubble chart with more than 2 variables. 0
Move Chart with Text 0
Possible to Combine reports to's to a single box? 0
Adding a comment in a footnote area 1
Embed the same Excel multiple times 0
Chart Plot Area changes in Excel 2007 0
Plot area changed after reopen document 0

Top