| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Min Function Excluding Zero Values & More | Excel Worksheet Functions | |||
| hiding zero values in charts | Charts and Charting in Excel | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| XY Scatter Legend when Edit Individual Markers | Charts and Charting in Excel | |||
Linear Mode
