Can I change legend keys to rectangular instead of square in exce.

[Guest]

Does anyone know how to change legend keys in bar graph to rectangular (like
in column graph) instead of the default square key?

 

[Guest]

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.

 

[Guest]

John,

Thanks very much for that. I only have a couple of legends to replace, so I
will use the method you described.