Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2-column legend
Is there any way to make a legend use a 2-column (or more) format
rather than one column? I have Excel 2003 and 2007 on various PCs. Thanks, Alan |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2-column legend
One option might be to create the legend as you want it to look using
worksheet cells as opposed to the chart itself. Once created, use Excel's "Camera Tool" to create a linked picture of the legend range. You can then bring that linked picture into your chart as the legend. -- John Mansfield http://cellmatrix.net "Alan" wrote: Is there any way to make a legend use a 2-column (or more) format rather than one column? I have Excel 2003 and 2007 on various PCs. Thanks, Alan |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
2-column legend
Select the legend, and resize it. As you drag the edges, the "cells" of the
legend's entries are shown with dashed lines. If you make the legend shorter and wider, at some point it divides into two columns of legend entries. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Alan" wrote in message oups.com... Is there any way to make a legend use a 2-column (or more) format rather than one column? I have Excel 2003 and 2007 on various PCs. Thanks, Alan |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
2-column legend
Thanks! I thought there must be an easy way . . .
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Legend Key Box | Charts and Charting in Excel | |||
Legend | Charts and Charting in Excel | |||
Legend - Don't Want To See | Charts and Charting in Excel | |||
Legend | Charts and Charting in Excel | |||
legend | Charts and Charting in Excel |