| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can I change legend keys to rectangular instead of square in exce.
Does anyone know how to change legend keys in bar graph to rectangular (like
in column graph) instead of the default square key? |
|
#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/exce..._from_picture/ The drawback would be if you're building a lot of charts at one time, this process could get tedious. ---- Regards, John Mansfield http://www.pdbook.com "BlondRapunzil" wrote: Does anyone know how to change legend keys in bar graph to rectangular (like in column graph) instead of the default square key? |
|
#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 Mansfield" wrote: 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/exce..._from_picture/ The drawback would be if you're building a lot of charts at one time, this process could get tedious. ---- Regards, John Mansfield http://www.pdbook.com "BlondRapunzil" wrote: Does anyone know how to change legend keys in bar graph to rectangular (like in column graph) instead of the default square key? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cursor Keys does not change cell focus | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How do I change the order of the legend entries? | Charts and Charting in Excel | |||
| How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
| Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Hybrid Mode
