I'll start this by saying I searched for an answer both here and on the google machine but not having the right words to look for it makes it hard to find an answer
so here's my problem, I have a pivot table that contains hours worked and the % of the total hours out of everyone worked. The pivot table I have set up fine. its the chart I want to clean up. I when I make the chart from the pivot table it brings over the % as well, this I don't want. at least not in the chart im working on. How do i get the chart to display only the hours in stacked columns while leaving out the % of total hours. see the attachement and thank you for the help
Capture.PNG
Bookmarks