+ Reply to Thread
Results 1 to 2 of 2

How do I split a chart legend into 2 columns?

  1. #1
    katew100
    Guest

    How do I split a chart legend into 2 columns?

    The legend in my chart has about 8 items and I cannot get them to split into
    two columns. The legend is subsequently very tall and has to go at the bottom
    of the chart as company standard so is making the chart look unprofessional.
    Can anybody help?

  2. #2
    Andy Pope
    Guest

    Re: How do I split a chart legend into 2 columns?

    Hi,

    The layout of items in the legend is automatically determined by the
    height and width of the legend box.
    You will need to make the legend width enough to display the legend
    entrys text for both columns.

    Move the legend over to the left and make it as wide as possible. This
    should then display columns, if it will fit. You can then reduce the
    size to something more appropriate but up to the point a single column
    appears.

    Cheers
    Andy

    katew100 wrote:
    > The legend in my chart has about 8 items and I cannot get them to split into
    > two columns. The legend is subsequently very tall and has to go at the bottom
    > of the chart as company standard so is making the chart look unprofessional.
    > Can anybody help?


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1