+ Reply to Thread
Results 1 to 6 of 6

Legend Spacing is HUUUUGE

  1. #1
    Registered User
    Join Date
    07-18-2018
    Location
    Vancouver
    MS-Off Ver
    16 for Mac
    Posts
    8

    Legend Spacing is HUUUUGE

    I added a new series to a chart and all of a sudden the spacing on the legend went HUGE. I can't seem to figure out how to adjust. Google digs up answers that don't seem to apply the the version of excel that I'm using.

    Untitled-1.jpg

    It used to look like this!

    Untitled-1.jpg

    Any ideas?

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Legend Spacing is HUUUUGE

    charts have properties. can't you open them and manipulate it accordingly? not to mention the fact that in the first image, you seem to have 2 differentiated square areas. one nested inside another. and in the bottom image, all of the content, the legend included, is in one enclosed area. do you see that?

  3. #3
    Registered User
    Join Date
    07-18-2018
    Location
    Vancouver
    MS-Off Ver
    16 for Mac
    Posts
    8

    Re: Legend Spacing is HUUUUGE

    The second selected "square" happens when you select an item within the chart, whether it's the title, the x-axis or legend (etc). You end up with a selection box around the element you're editing as well as the overall chart.

    In the second image, only the overall chart is selected because I haven't selected anything specific within the chart area to edit.

    What "properties" menu/tab am I supposed to open to edit spacing? As you can see there is a properties drawer on the right hand side of the image with options, none of which control line spacing for the legend.

    Any ideas?

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Legend Spacing is HUUUUGE

    by properties, I meant the dialog boxes associated with every element of a chart. for instance, the graph itself, the legend, the lines in the chart, etc, etc....

    literally everything can be manipulated and/or changed through a menu in the interface.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Legend Spacing is HUUUUGE

    You can not change the size of position of chart elements with UI. It is all done with the mouse.

    You will need to either reposition plot area and legend with mouse.
    Or apply a layout style, Chart Tools > Design > ChartLayout > Quick Layouts
    Cheers
    Andy
    www.andypope.info

  6. #6
    Registered User
    Join Date
    05-03-2023
    Location
    Mountains
    MS-Off Ver
    365
    Posts
    1

    Thumbs down Re: Legend Spacing is HUUUUGE

    The line spacing in the legends is fixed. It defaults to double line spacing every time. And none of the above suggestions work.
    I can't access paragraph settings while in a chart, and the useless format chart area section does not have a paragraph option and half the text options are greyed out.
    (Even though grey I can see that there is no option to fix.)
    Resizing the legend text box does not work, and reformatting the whole chart does not work.
    Once again Microsoft has tried so hard to be helpful that they've become useless.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change the spacing between legend points
    By summertimebee in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-08-2017, 03:48 AM
  2. Spacing between legend entries too wide
    By davidx in forum Excel General
    Replies: 3
    Last Post: 09-09-2014, 10:58 AM
  3. Spacing
    By bjcowen9000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2013, 04:00 AM
  4. Rows Spacing, Column Spacing
    By Pukka83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2008, 12:05 AM
  5. Legend Line Spacing
    By Bill Sturdevant in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-06-2005, 08:05 AM
  6. SPACING
    By RAJEEV CHADHA in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2005, 10:06 AM
  7. [SOLVED] Spacing
    By Greg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-31-2005, 12:06 PM

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