I have a pivot table chart that sums how many times different people used our website. The pivot table shows everyone sorted largest to smallest which is great. For the chart, I only want to focus in on those who have visited more than 50 times. How do i do this?
Thanks,
Vicki3809
Pivot Table and the chart is linked.
So to show only those with 50 visits or more, you need to apply value filter to the pivot table Value field > 50.
If you want to show Pivot with all data, but 50+ only for chart. You will need to copy the pivot (i.e. 2 pivots, one linked to chart. Other independent).
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
thanks for the info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks