G Guest Mar 16, 2005 #1 Does anyone know how to change legend keys in bar graph to rectangular (like in column graph) instead of the default square key?
Does anyone know how to change legend keys in bar graph to rectangular (like in column graph) instead of the default square key?
G Guest Mar 17, 2005 #2 One option would be to delete the standard legend and replace it with a custom "picture" legend. You can then make the legend keys any size or shape that you wish. The process described here might help: http://www.pdbook.com/index.php/excel/create_legend_from_picture/ The drawback would be if you're building a lot of charts at one time, this process could get tedious.
One option would be to delete the standard legend and replace it with a custom "picture" legend. You can then make the legend keys any size or shape that you wish. The process described here might help: http://www.pdbook.com/index.php/excel/create_legend_from_picture/ The drawback would be if you're building a lot of charts at one time, this process could get tedious.
G Guest Mar 17, 2005 #3 John, Thanks very much for that. I only have a couple of legends to replace, so I will use the method you described.
John, Thanks very much for that. I only have a couple of legends to replace, so I will use the method you described.
