+ Reply to Thread
Results 1 to 4 of 4

Marker size or shape in legend for combo chart

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2016, 32-bit
    Posts
    92

    Marker size or shape in legend for combo chart

    I currently have a combo chart (stacked column with a line showing the average). When I create a regular stacked column chart, the legend entry markers are squares. However, when I add the line as a combo chart, the markers become rectangles. It seems like this goes back quite a few versions of Excel from pictures I've seen on Peltier's blog.

    Does anyone know if this can be changed? It looks odd in the presentation I have because the "Average" line looks almost as thick as the rectangles representing the series.

    Thanks in advance!!

    -njs


    (Using Excel 2013)

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

    Re: Marker size or shape in legend for combo chart

    The marker will elongate as soon as you mix chart types with a line.

    You can either remove it from the legend and label the line itself or resort to a shape for the legend entry
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-12-2013
    Location
    USA
    MS-Off Ver
    Excel 2016, 32-bit
    Posts
    92
    Quote Originally Posted by Andy Pope View Post
    The marker will elongate as soon as you mix chart types with a line.

    You can either remove it from the legend and label the line itself or resort to a shape for the legend entry
    Is there a reason they change it for these chart types?

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

    Re: Marker size or shape in legend for combo chart

    Probably, but I doubt they every shared the reason.

+ 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. [SOLVED] Chart Marker Builtin Customize picture - size required.
    By thilag in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-13-2016, 12:18 PM
  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. VBA Chart - defining Legend placement and size
    By PRodgers4284 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-04-2012, 08:08 AM
  4. Scatter chart marker shape bug
    By Nutkees in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-22-2008, 11:07 AM
  5. 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
  6. How can I change the shape and size of the boxes in an org chart?
    By helenfanig in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-02-2006, 02:20 PM
  7. [SOLVED] Default Marker Size on Chart
    By Bill in forum Excel General
    Replies: 1
    Last Post: 08-08-2005, 06:05 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