Thread: Numerical Label on top of each bar instead of percentage [3-d Column Chart]

Usually, when I'm making a 3D column chart I manually label the top of each bar.

Excel, automatically puts the percentage label on top but I want the numerical total instead.

As I will be making a lot of graphs, I want to know if there is some short-cut way of doing this ?

Attached is the document that I'm working with, I have changed the first two bars to demonstrate what I want to do.

Thanks for you help!

Hi,

I am using XY scatters to do the labeling in most of my charts. There is a nice little Excel add in called: Chart Labeler - available at: http://appspro.com/Utilities/ChartLabeler.htm - which does the labeling for you.
XY-Scatters however cannot be combined with 3D-charts. Would 2D columns be an option for you?

Regards

Holger