+ Reply to Thread
Results 1 to 6 of 6

Chart legend marker sizes

  1. #1
    Registered User
    Join Date
    12-18-2013
    Location
    Alberta
    MS-Off Ver
    Excel 2010
    Posts
    12

    Chart legend marker sizes

    Perhaps this has already been addressed, but if so my search powers have failed me.

    When I put together a simple pie chart, there are markers in the legend corresponding to the colours of the pie slices. The only problem is that they are tiny - is there any way to enlarge them? The font size I can deal with, but I have not found a way to adjust just the marker size.

    Thanks.

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Chart legend marker sizes

    Hi -

    You should be able to select the legend box, right mouse button click, and then set the font parameters (size, font, color, etc.). Without an example of your problem I'm kind of guessing at a solution. Can you upload a sample file that you're having difficulty with?
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  3. #3
    Registered User
    Join Date
    12-18-2013
    Location
    Alberta
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Chart legend marker sizes

    Thank you for your quick reply.

    The font used in the legend is not an issue. I can change size, colour and so forth of the letters, no problem.

    The problem is the little box of colour beside the letters, corresponding to the colours of the pie chart itself. If the pie has a red slice for, say, Income and a blue slice for Taxes, then there will be small small boxes, red and blue respectively, beside the legend words Income and Taxes.

    I can change the colour of the 'slices' and thus the colours of the boxes in the legend, too. What I am stuck at is how to make those little boxes or markers bigger.

    I would be happy to upload an example, but - no sarcasm intended, I assure you - but that implies a skill level my decrepit brain lacks. If I knew how to do that, I probably wouldn't be here in the first place.

  4. #4
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Chart legend marker sizes

    Hi -

    The little squares are proportional to the font size. So, if you adjust the font size up, the little squares get bigger too.

    Hope that helps.

  5. #5
    Registered User
    Join Date
    12-18-2013
    Location
    Alberta
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Chart legend marker sizes

    Drat. I had hoped it was all due to ignorance and inexperience at my end.

    Thanks very much.

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

    Re: Chart legend marker sizes

    Add a dummy data point and format that entry only.
    Attached Files Attached Files
    Cheers
    Andy
    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)

Similar Threads

  1. 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
  2. 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
  3. Changing the marker style on a chart
    By springboardjg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2011, 10:22 AM
  4. Series Marker on Chart
    By Ralem in forum Excel General
    Replies: 5
    Last Post: 04-20-2010, 04:17 AM
  5. Chart Marker Border
    By pogopuschel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2010, 07:27 PM
  6. Scatter chart marker shape bug
    By Nutkees in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-22-2008, 11:07 AM
  7. [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

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