+ Reply to Thread
Results 1 to 8 of 8

Change marker size on legend

  1. #1
    Registered User
    Join Date
    12-13-2016
    Location
    Bolivia
    MS-Off Ver
    Office:Mac 2011 v.14.0.0
    Posts
    4

    Change marker size on legend

    I would like to increase the size of the markers inside the legend in a chart. Is it possible? How?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Change marker size on legend

    Hi and welcome to the forum

    I don't think you can change the marker size without changing the font size.
    Select the Legend object then right click when it's selected, choose font and alter the size.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-13-2016
    Location
    Bolivia
    MS-Off Ver
    Office:Mac 2011 v.14.0.0
    Posts
    4

    Re: Change marker size on legend

    Thanks, Richard. Are you sure that you cannot change as you can change them inside the line charts?

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Change marker size on legend

    No, I can't be completely sure. There may be some esoteric work around.

    However there's a fundamental difference between markers for chart series and the marker in a legend. The line series markers are individual objects in their own right. The Legend is essentially a single object.

    The matter is also discussed here.

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Change marker size on legend

    Hi,

    It is not possible, as far as I am aware, to make the markers larger than they appear in the chart. However, you can change the font size for the legend and then reduce the font size for each individual label. That will make the markers their maximum size whilst controlling the font size.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  6. #6
    Registered User
    Join Date
    12-13-2016
    Location
    Bolivia
    MS-Off Ver
    Office:Mac 2011 v.14.0.0
    Posts
    4

    Re: Change marker size on legend

    Thanks, "xlnitwit"! Good 'bridge' to obtain the result needed.

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Change marker size on legend

    You're welcome and thank you for the rep.

    I'm pleased to know it works on the Mac as so many things do not!

  8. #8
    Registered User
    Join Date
    12-13-2016
    Location
    Bolivia
    MS-Off Ver
    Office:Mac 2011 v.14.0.0
    Posts
    4

    Re: Change marker size on legend

    I'm sorry, it doesn't work on Mac. When you change de font for the last 'variable', all markers goes to their minimum size.

    The way I'm using now is: set the font size for legend larger and choose "Superscript" with "Offset: 1%". The size appearance of the font is reduced and similar of the rest in the chart.

+ 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. Chart legend marker sizes
    By Maxwel in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-12-2016, 03:36 AM
  2. Marker size or shape in legend for combo chart
    By njs27 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2016, 03:13 AM
  3. Dynamically Change Marker Size and Background Colour for XY Scatter
    By MJU007 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-05-2016, 05:19 PM
  4. Legend Marker Fill Pattern with VBA
    By swamp rat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2015, 04:20 AM
  5. Replies: 0
    Last Post: 06-29-2013, 04:25 AM
  6. [SOLVED] Change the size of a chart marker in the legend
    By Thea in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2006, 04:45 PM

Tags for this Thread

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