Hi all!
I am working on a Pivot Table and chart, based on another sheet that is already fully populated with data.
The Pivot Table seems to have a mind of it's own though.
It has replaced the values from cells that were empty, with Zero.
I am actually making a plotted graph based on this pivot table and I would like the the graph to stop, where there is no more data.
Not make a dive down to zero - when in fact, there was never a zero value entered to begin with.
I find lots of tutorials for people who would like to turn blanks into zero, but I find nothing for the opposite direction.
Please see illustration. Hope somebody knows how to fix this.
Bookmarks