I am trying to figure out how to prevent Excel from Plotting data that has a sum of zero in a Pivot table. Please see attached.
In the attached on the "PV Pareto of all defects" tab you will see that it plotted Criteria #'s 32,5,7,12,31,14,29,1,30,9,22,27,21,19,15,13. All have Zero value. How do I prevent Excel from showing these without having to remove and/or add manually every time I want to run my charting?
Do not plot if value is =0 or blank.
Thank you very much!
Bookmarks