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

Similar Threads

Create a chart from a table in word thats dynamic 0
Doughnut Chart linked with the slicer in the pivot table 0
Dynamic charts with named range Windows 8.1 3
Move Chart with Text 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Dynamic date range 1
Chart with Named Range error 1
Excel 2007 graphs/charts automatically populate with new data 1

Top