Adding percentages/rates on data

Hello,

I'm trying to express a graph where its a stacked column. Blue being a numerator and gray being the denominator. I've been manually putting in the rates (num/denom) on each graph. Is there a way I can sexcelfile.pngomehow hardcode it into the excel series where it automatically shows up? Thanks for your help.

try this:

• add data labels to your "all" series and align them as inside base, so they will appear above the "screened" bar
• right click on each individual label, and link it to the cell in your worksheet containing the percentage value for that series. Because this is a dynamic link, it will change as your number changes.

If this is a bit fussy, a macro will do it for you. I have assumed your percentage values are in range B6:G6, and that the "all" series is series 2. Change this as needed.

this one fixes the label's values at the contents of the source cell:

Please Login or Register  to view this content.

and this one links the label to the source cell, so it will change whenever the source cell changes:

Please Login or Register  to view this content.

It works! Thanks