Add suffix to chart label

[mikeymay]

I have a chart that has the last point being charted as a label on the line chart

The points in the chart are numeric values and I want to add a suffix of '(N)' to the point that is labelled so it shows '17,799(N)'

I can't seem to find a way of doing this.......


TIA

 

[hagia_sofia]

Hello, in "Label Options" you can choose "Value From Cells". So, maybe you could create a helper column which go something like this: =TEXT(A1:A10,"#,##0")&"(N)" where A1:A10 represents your original data. Then you would select these adjusted values via "Value From Cells".

 

[felixstraube]

Or you could format the data so it shows the "(N)" like this: