Displaying a Data Label on a Chart Using "Offset"

[BrianExcel]

Is there any way to create a label based on an offset value? Right now, I have a bar chart being fed from 2 separate rows of data. Then, below that data, I have a couple of formulas/calculations that gives me the percentage for each one.

I want the chart to be based on the actual numbers that are being used as source data for the chart, but the %s underneath them to be used as the labels.

Anyone know how to do that? I am using Excel 2010.

 

[Steve=True]

Hello BrianExcel,

Try this technique. No offset needed.[h=2]How-to Put Percentage Labels on Top of a Stacked Column Chart[/h]http://www.exceldashboardtemplates.com/tag/stacked-column-chart/

Please let me know if this helps.

Thanks

Steve=True