Stacked Bar Chart with "different" data labels

[EasterGreen]

I want to prepare a multi year stacked bar chart with different product lines to show how revenue growth derives from different product lines.
But I want to put a data label on each chart element NOT showing revenue but average price (or both).
The attached is a standard stacked bar chart but I would rather have another data set inside the label, say $5 or $6 rather $100 for revenue.

 

[BSALV]

first you add the datalabels and afterwards you change the datalabels so that they don't show the values but the value of a range. That can be a text or in this case your average price.

 

[Jon Peltier]

BSALV gave the right answer, but I like seeing answers written out, rather than having to view a video.

The steps are easy: add data labels to the points, select a set of labels, and click Ctrl+1 to format the labels. In the task pane, check the Value from Cells option. A small dialog pops up, allowing you to select the range that contains your custom labels.