pareto chart in Excel 2007?

H

HBond

In Excel 2003, one of the custom graph styles was a bar chart with a line and
two vertical axes. It was possible to make beautiful Pareto charts with this
type of chart, to show categories of defects in decreasing frequency of
occurrence, with a line that showed the cumulative % of defects represented
by each defect category. In Excel 2007, I cannot find any capability for a
chart with two vertical (y) axes. Can someone please help?
 
A

Andy Pope

Hi,

The built-in combinations are not available in xl2007. so you need to create
your own.
Create a column chart based on both data series. Select the series to be
plotted as line and change the chart type.
Then select the series to be plotted on the secondary axis and change that
via Format dialog.

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 do you create combination charts (line-coulmn) in excel 2007? 1
Excel 2007 Bar and Line chart on 2 Axes 3
Odd chart type needed 2
Create 2-Axis Combination Chart XL 2007 2
Overlay charts in 2007 2
Stacked bar Chart in Excel 2007 1
Creating a new chart in Excel 1
Combination chart using VB2005 2

Top