How do I add values in the Legend?

[Romi.Kapur]

I am working in a bar chart on training targets & actual performed for
multiple locations, if I add values in the cahrt it gets cluttered, I would
like to add total series values in the Legend bar to show the overall
performance as compared to the target i.e. mainly two values ONLY.

[robert111]

if your legend is TOM and tom's value is 999, you need to concatenate the cell with tom in it and the cell with 999 in it and then use this new range of cells as your x axis labels