Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Legends - Changing the Shape of
Hi,
I've got two charts, charting ten items each. In one chart when I place the legend at the bottom it produces a wide box with two columns of five items in each column, resulting in a big space for the graph. The other chart has a legend also at the bottom, but with one column of ten items, resulting in a smaller graph. How do I manipulate the legend box to give me two columns for the items? I've tried dragging the placeholders, but it won't go into two columns. Thanks for looking. Paul |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Legends - Changing the Shape of
Hi,
Select the whole legend box and increase its width by dragging on of the sizing handles. The legend will automatically decide the layout depending on the legends size and number of entries. Cheers Andy Paul wrote: Hi, I've got two charts, charting ten items each. In one chart when I place the legend at the bottom it produces a wide box with two columns of five items in each column, resulting in a big space for the graph. The other chart has a legend also at the bottom, but with one column of ten items, resulting in a smaller graph. How do I manipulate the legend box to give me two columns for the items? I've tried dragging the placeholders, but it won't go into two columns. Thanks for looking. Paul -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Legends - Changing the Shape of
Thanks, that works fine.
Paul "Andy Pope" wrote: Hi, Select the whole legend box and increase its width by dragging on of the sizing handles. The legend will automatically decide the layout depending on the legends size and number of entries. Cheers Andy Paul wrote: Hi, I've got two charts, charting ten items each. In one chart when I place the legend at the bottom it produces a wide box with two columns of five items in each column, resulting in a big space for the graph. The other chart has a legend also at the bottom, but with one column of ten items, resulting in a smaller graph. How do I manipulate the legend box to give me two columns for the items? I've tried dragging the placeholders, but it won't go into two columns. Thanks for looking. Paul -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
Determine shape name associated with a specific cell | Excel Discussion (Misc queries) | |||
Capturing Shape Name/Text from OnAction property | Excel Discussion (Misc queries) | |||
Why oh why are my comment boxes changing shape? | New Users to Excel | |||
changing comment indicator size or shape | Excel Worksheet Functions |