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

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

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