Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Paul
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Paul
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing format of number without changing the value sweetsue516 Excel Discussion (Misc queries) 2 August 22nd 05 04:07 PM
Determine shape name associated with a specific cell [email protected] Excel Discussion (Misc queries) 1 May 12th 05 12:49 AM
Capturing Shape Name/Text from OnAction property William Bartusek Excel Discussion (Misc queries) 3 April 12th 05 06:38 PM
Why oh why are my comment boxes changing shape? Marc New Users to Excel 1 April 1st 05 03:54 AM
changing comment indicator size or shape Mrocka Excel Worksheet Functions 1 December 13th 04 03:53 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"