How do you create combination charts (line-coulmn) in excel 2007?

G

Guest

I need to create a combination chart (Pareto line-column) in excel 2007 but I
can't find the combination chart wizard like the one in 2003. How do I go
about creating a line-column chart in 2007.
 
A

Andy Pope

Hi,

In 2007 you need to build your own combinations.
Start with a column chart based on all the data. Then select the column
series you wish to plot as line. You can now change the chart type.
Chart Tools > Design > Type > Change 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

Create 2-Axis Combination Chart XL 2007 2
pareto chart in Excel 2007? 1
How to create a bubble chart with more than 2 variables 0
Combination charts 1
Overlay charts in 2007 2
How to create a stacked bar, line combination chart 2
Excel 2007 Bar and Line chart on 2 Axes 3
How to create a custom line and column chart in excel 2007 1

Top