Showing values as a percentage in a bar chart - but keeping scale as the values

bruty

Active Member
Joined
Jul 25, 2007
Messages
445
I currently have a set of data the is shown in a column chart. At the moment, the 'y' axis has the scale set to the values and each bar is shown as the value itself.

Is there anyway of showing the figure on the bar as a percentage of the total for that bit, whilst keeing the 'y' axis as the values?

Hope this makes sense??

Please note this is for a column chart, not bar chart
 
Last edited:

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,938
Messages
5,508,228
Members
408,670
Latest member
lhmwnrexcel

This Week's Hot Topics

Top