I have several pareto charts including cummulative percentages which
are built from pivot table data which is constantly changing. (Note:
I have copied the pivot table data into regular cells)  I have tried
to use the dynamic range chart, however, because there zeros the
dynamic range still shows all the values.  Also keep in mind I have
tried all the hiding zero methods commonly used to make them
invisible.

Please Help!

Excel 2007 PivotTable, PivotChart
Histogram, Pareto
Zeros not counted.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_24_09.xlsx

On Dec 24, 1:15=A0pm, Herbert Seidenberg <herbds7-ms...@yahoo.com>
wrote:
> Excel 2007 PivotTable, PivotChart
> Histogram, Pareto
> Zeros not counted.http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_24=
_09.xlsx

Herbert,

Thank you for your help, however, I need cumulative percent to show on
the same chart as a line.

Thanks,

JMT

Excel 2007 PivotTable, PivotChart
Histogram, Pareto
Added cumulative line.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_24_09.xlsx