Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
pareto chart in Excel 2007?
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pareto Chart | Charts and Charting in Excel | |||
Pareto Chart | Excel Worksheet Functions | |||
Pareto Chart | Charts and Charting in Excel | |||
how do you create a Pareto Chart | Charts and Charting in Excel | |||
How do I set up a Pareto chart in Excel? | Charts and Charting in Excel |