pareto chart in Excel 2007?

[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?

 

[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