+ Reply to Thread
Results 1 to 4 of 4

How to change order of Chart Legend in VBA

  1. #1
    Registered User
    Join Date
    03-11-2020
    Location
    Bloomington
    MS-Off Ver
    2018
    Posts
    22

    Question How to change order of Chart Legend in VBA

    Hi Everyone,

    I'm trying change the order of the words in my chart's legend.

    What it looks like now:
    4-20 pic1.png

    The order I would like:
    1. Documentation to be provided
    2. In-Progress
    3. Complete
    4. NA

    Thank you!!

    Here's my code:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,783

    Re: How to change order of Chart Legend in VBA

    Quote Originally Posted by excelhelp31120 View Post
    ... change the order of the words in my chart's legend ...

    The order I would like:
    1. Documentation to be provided
    2. In-Progress
    3. Complete
    4. NA
    Try:
    Please Login or Register  to view this content.

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

    Re: How to change order of Chart Legend in VBA

    You might want to include the crossesat property in order to have the horizontal axis at the bottom

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,783

    Re: How to change order of Chart Legend in VBA

    Of course ... yes ... : )

+ 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. Sorting Chart Legend In Order Of Results
    By King_Crud in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-16-2013, 09:30 AM
  2. Chart Legend appears in Reverse Order
    By Guido Meng in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2013, 08:13 PM
  3. Change order of Legend without changing the order of the chart
    By Grimace in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-22-2012, 11:53 AM
  4. [SOLVED] how can I change the order of trendlines in a legend?
    By dutchy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-06-2011, 05:15 AM
  5. [SOLVED] Series order in a chart legend.
    By Phil in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-28-2005, 04:05 PM
  6. Chart Legend - Order of Entries
    By Ron in forum Excel General
    Replies: 4
    Last Post: 06-07-2005, 09:05 AM
  7. [SOLVED] How do I change the order of the legend entries?
    By Kerrin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-10-2005, 06:06 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