hi
I've created a pivot from a table, week 1-52
the table is updated weekly with fresh data.
if i hide the zeros in the pivot the fresh data isn't picked up when inputted.
i want to hide the zeros to keep the chart neat
any help would be appreciated
thanks
Hello deanop2 and Welcome to Excel Forum.
It may help if we could see a sample of the data and pivot table with the formatting method used to hide zeros applied.
Instructions for uploading an .xlsx file are given in the banner at the top of the page.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks