Chart series with some data labels

Originally Posted by robotmannick

Hi all,

I have an area chart with 5 series in it. I would like to include data labels on the last entry of each series only.

I know that you can include data labels for the whole series and then delete those individual labels that are not required but that seems like a bit of a long-winded way of doing it.

Is there a more simple way?

Thanks,

Remove the Category X Axis and use a Category X Title, positioned under the last data item, but you will need to hard-enter this and re-position it each time the range expands, it is not dynamic from the cell.

Another possibility is to have the data cells reflect a value in the last cell only, but this is really no more simple than entering the range in the last cell and deleting the prior one.

---