+ Reply to Thread
Results 1 to 3 of 3

Edit a chart legend order with trendlines?

  1. #1
    Registered User
    Join Date
    09-21-2018
    Location
    Indiana, USA
    MS-Off Ver
    Office for Mac
    Posts
    6

    Edit a chart legend order with trendlines?

    I have this chart and I was wondering if there is a way to change the legend around. If not, I can just save it as a picture and do a lot of pasting and cutting. It would also help to know for future reference.

    Screenshot (12).png

    2018 Revenue, Capital RTD, and Capital Raise Rounds are all legend entries and I have the 3 linear trendlines for each.

    Right now it is ordered as:

    2018 Revenue-----------Capital RTD

    Capital Raise Round-----Linear(2018 Revenue)

    Linear(Capital RTD)-----Linear(Capital Raise Round)


    And I want it to be:

    2018 Revenue-----------Linear(2018 Revenue)

    Capital Raise Round-----Linear(Capital Raise Round)

    Capital RTD--------------Linear(Capital RTD)


    Thanks!

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Edit a chart legend order with trendlines?

    I think you'd have to plot the trendline data yourself to get that. As a simpler option, you could go for a legend that is 3 columns and two rows, then the trendline legend entries should be directly below the corresponding series.
    Rory

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

    Re: Edit a chart legend order with trendlines?

    The order within the legend is lock by excel. You can to some degree alter the order of series but trend lines will be at the end.

    One was is to add dummy series to the chart to actual as legend entries only.
    Apply trends to the real data series and then delete the individual entries from the legend.
    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. Chart with 3 trendlines but cannot edit them
    By Pete291 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-02-2018, 12:43 PM
  2. 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
  3. Chart Legend appears in Reverse Order
    By Guido Meng in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2013, 08:13 PM
  4. 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
  5. [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
  6. [SOLVED] Series order in a chart legend.
    By Phil in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-28-2005, 04:05 PM
  7. Chart Legend - Order of Entries
    By Ron in forum Excel General
    Replies: 4
    Last Post: 06-07-2005, 09:05 AM

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