software

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

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:
gt; Hi,
gt; I've got two charts, charting ten items each. In one chart when I place the
gt; legend at the bottom it produces a wide box with two columns of five items in
gt; each column, resulting in a big space for the graph. The other chart has a
gt; legend also at the bottom, but with one column of ten items, resulting in a
gt; smaller graph.
gt;
gt; How do I manipulate the legend box to give me two columns for the items?
gt; I've tried dragging the placeholders, but it won't go into two columns.
gt;
gt; Thanks for looking.
gt;
gt; Paul

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Thanks, that works fine.

Paul

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Select the whole legend box and increase its width by dragging on of the
gt; sizing handles. The legend will automatically decide the layout
gt; depending on the legends size and number of entries.
gt;
gt; Cheers
gt; Andy
gt;
gt; Paul wrote:
gt; gt; Hi,
gt; gt; I've got two charts, charting ten items each. In one chart when I place the
gt; gt; legend at the bottom it produces a wide box with two columns of five items in
gt; gt; each column, resulting in a big space for the graph. The other chart has a
gt; gt; legend also at the bottom, but with one column of ten items, resulting in a
gt; gt; smaller graph.
gt; gt;
gt; gt; How do I manipulate the legend box to give me two columns for the items?
gt; gt; I've tried dragging the placeholders, but it won't go into two columns.
gt; gt;
gt; gt; Thanks for looking.
gt; gt;
gt; gt; Paul
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;