LinkBack URL
About LinkBacks
Hey Guys,
I have a pivot table chart that plots 0, blanks as the raw data pivot is talking to cannot be changed.
Is there any way that I my Pivot Chart stops plotting 0s and blanks when I press refresh to auto update the values?
Thanks.
Hey Guys,
I have a pivot table chart that plots 0, blanks as the raw data pivot is talking to cannot be changed.
Is there any way that I my Pivot Chart stops plotting 0s and blanks when I press refresh to auto update the values?
Thanks.
Excel 2007 => red button on the left corner.
options for excel
advanced
Vieuwoptions for this sheet
uncklick *4 option" show an zero in cells with an zero-value.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thank you....it still plots blanks
You get better and quicker help if you add the excel file, without confidential information.
Please add manualy the desired (expected) result.
sample file attached. I don't want to manually click on the filters to remove blank.
Book1.xlsx
The only option I know is by filtering those data.
See the attached file.
yeah..the original file has pivots which will be hidden for end users.
They will only see the graphs so i was looking for a solution where blanks can be excluded without having to filter them.
thank for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks