Hi,
I have a pivot table that is summarised in a nice dynamic chart. I have a range of values in this chart that have a lot of 0's in it. Is it possible for either the pivot table or the graph to exclude these 0's so it only shows the figures greater than 0?
Screen shot attached should help show what I mean. The little circles are the graph are linked to column 'Sum of RS eBay Listings'.
Many thanks,
Ben
ee.jpg
1 way to stop zero's from appearing on a chart, is to construct a formula that produces N/A for the answer, instead of 0
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
This is the formula I'm currently using - =IFERROR(1/(1/SUMIF(Table1[Date],G107,LISTINGS!D:D)),"Figure not obtained"). How would I get it to display no results as N/A?
Ben
Change "Figure not obtained" to NA() or "#n/a"
Last edited by shg; 12-01-2013 at 07:59 PM.
Entia non sunt multiplicanda sine necessitate
Thanks for the assist shg
Hi,
Thanks for the tip/s. However it doesn't seem to have worked - when I input #n/a it updated but when refreshing the pivot table it still displays the values as zero.
Thanks,
Ben
That has to be in the formula that gets pulled into the PT
It is, the formula is now - =IFERROR(1/(1/SUMIF(Table1[Date],G37,LISTINGS!D:D)),"#n/a")
This is in the table that the pivot table is linked to.
Ben
Can you upload a sample workbook?
eBay Stats EXAMPLE.xlsx
Hi,
See attached.
Thanks,
Ben
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks