View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default pareto chart in Excel 2007?

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"HBond" wrote in message
...
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?