Hello,
I have a pivot table chart that isn't fully updating as I navigate into it deeper with the use of a slicer.
When I dig deeper, eventually my pivot table just includes the data label on the far end 'bar', or whatever the last label happens to be. This occurs no matter which way I go into my filters. (screenshot attached).
Is there a way to get the number above each bar on the graph?
Thank you!
Really hard to offer any advice based on a picture.
Is it possible you formatted individual points on the series, rather than the whole series?
My apologies for just a picture, but thank you for the response.
The chart acts as if all of the other points are on the bar, meaning when I click on the ''8", it highlights where every other point should be showing on each bar. If I change the chart type, it will update and show all of the values - but then they disappear when I click into a different filter.
Can you post example file as I have not seen that behaviour before.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Last edited by Andy Pope; 04-27-2019 at 04:16 AM. Reason: removed text from canned reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks