How can I add multiple source data data labels?

[Julian Iles]

To be more exact, I require my original data labels (in an Area Chart in
Excel) to remain visible, ie £250,444; in addition I require to show on the
same drop line, either above or below this original figure, the Loan To Value
amount, ie 48%.

I am sure this is possible, however I am unable to discover the correct
process to enable this eventuality.

 

[Shane Devenshire]

Hi,

First you need to create a concatenated formula in the spreadsheet, then you
need to use a custom add-in to use those cells a data labels.

Assume you 250,444 is in column B and the 48% is in column C then in column
D enter thr formula =TEXT(B1,"£###,###")&" - "&TEXT(C1,"%")

you can download the xl chart labeler from

http://www.appspro.com/Utilities/ChartLabeler.htm

If this helps, please click the Yes button

Cheers,
Shane Devenshire