Dynamic Range Chart and Ignoring Zeros

  • Thread starter Thread starter AFuturePrez
  • Start date Start date
A

AFuturePrez

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!
 
Back
Top