Hi all,
Total noob to the forum. I have tried to find out if this question has been asked before, but I couldn't see it. My problem is that I have a created a stacked column pivot chart (shown below) and I want to add data labels representing the percentage mix within each column, whilst retaining the absolute values as the Y axis.
I have tried going into value field settings, and in the show values as tab selecting the % of column total. That gives me the percentages across the x axis, not the Y axis (meaning if I add left to right I get 100%, but I don't get 100% within the column). I tried all the other options in the show values tab and nothing worked.
Excel chart question.png
Any ideas.
Bookmarks