Data labels in Excel Charts

[Esoterik]

Hi, new to this forum so hello all. Here's my problem, hope you can help. I've got a chart I'm trying to make for a friend and I'd like to add data labels to the chart that are not related to the data the chart corresponds to.

The chart is 3 bars each representing 100% one shade is sales in percentage and the other shade is surplus in percentage. I'd like the data label to show the number of sales/surplus rather than the percentage. Is this possible? Thanks in advance.

[Andy Pope]

Try this free addin which will allow you to link data labels to cells
http://www.appspro.com/Utilities/ChartLabeler.htm

In the cells use formula to construct the information you want displayed