Showing percentages above bars on Excel column graph
charts, excel, excel-formula
Solution
Either
- Use a line series to show the %
- Update the data labels above the bars to link back directly to other cells
Method 2 by step
- add data-lables
- right-click the data lable
- goto the edit bar and type in a refence to a cell (C4 in this example)
- this changes the data lable from the defulat value (2000) to a linked cell with the 15%
Problem
I have a graph that is pulling data from a PivotTable, so I get a distribution of counts (how many in category A, how many in B, how many in C, etc) But above each bar I also want to show a percentage of the whole. So for example I might be able to say "This bar for Category A shows we clearly have 2000 of it, but see the number on top of the bar, it's only 15% of the total" Does this make sense?