Hi
I like to think I am fairly good with excel but I need some help in understanding how to add % values to a bar chart that has absolute values (as opposed to %'s) on the y-axis.
All I am trying to do is graph a bar chart with absolutes on the y-axis, elect to display values, and have the values show as %'s on the bars, but this seems impossible and the only way to do it is overtype the values with the right % amounts (which is not very helpful if the numbers change later)!
Any help gratefully appreciated.
Thanks
Bookmarks