Dynamic Range Chart and Ignoring Zeros

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top