Morning,
Is it possible to have 2 data labels per column/bar in a column/bar Pivot Chart?
1. Show values as 'No Calculation'
2. Show values as '% of column total'
Cheers
Morning,
Is it possible to have 2 data labels per column/bar in a column/bar Pivot Chart?
1. Show values as 'No Calculation'
2. Show values as '% of column total'
Cheers
Either use the same value field twice, set the first one to sum and the second to %, or drop it into both row and value fields, then just set the value as %age.
edit:-
Sorry, I misread it as pivottable, have a look at this link, see if that does what you need.
https://excelribbon.tips.net/T007888...ph_Column.html
Last edited by jason.b75; 09-08-2018 at 05:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks