+ 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
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,044

    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
    Days when we raged, we flew off the page
    Such damage was done

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,466

    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)

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