Hello. How can you get excel to ignore zeros in a pivot line chart? Thanks.
Hello. How can you get excel to ignore zeros in a pivot line chart? Thanks.
Try this -
On the Row Lable of your Pivot Data > Value Filter > Greater Than > 0
Cheers!
Deep
Last edited by NeedForExcel; 06-25-2015 at 11:41 PM.
Cheers!
Deep Dave
Hi, I do not get what you say. In the value field I don't see the greater than. Please advise.
Thanks
The Value Filter is in the written part at the top part of the dialogue box just under the sort options (6 down from the top in Excel 2010). Click on that and another dialogue opens. Choose Greater Than then fill in the filter fields.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Watch this video to see where Value Filters are:
http://www.contextures.com/excel-piv...ers-top10.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Got it.
Thanks for replay so fast.
How can I set status as a SOLVE?
Thanks
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Hi, I can't see that option.
I have:
Show printable version
Email this page
Unsubscribe from this thread
Nothing else.
Thanks
Upon examination of the thread, you didn't start the thread but inadvertently hijacked it. You should have started your own thread on the topic. This should have been caught earlier by folks such as myself but missed it. Take a look at the rules. Rule #2 covers this.
Since the thread wasn't started by you, you cannot mark the thread as solved.
ok, Sir.
I just read the rule #2
Thanks
I have a question.
Since I am checking and reading questions from other users, and since I have the same questions, it looks like it is not allowed to write anything there, right?
Please help me where to go to star a new inquiry or question. Every time it takes me a lot of time to find it.
I have wrote in another user before you send me the rule #2. Calculating in a pivot.
Thanks for you help and time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks