ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add values in the Legend? (https://www.excelbanter.com/excel-discussion-misc-queries/97731-how-do-i-add-values-legend.html)

Romi.Kapur

How do I add values in the Legend?
 
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

How do I add values in the Legend?
 

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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=558737



All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com