+ Reply to Thread
Results 1 to 6 of 6

How to make legend color consistent across graphs?

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    How to make legend color consistent across graphs?

    Hi Forum,

    I have 2 graphs, graph 1 and graph 2 (pl see attahced).

    Data for Graph 2 were derived using data used for Graph 1 (but I have more other graphs in my original problem where source data are not inter-dependent).

    My problem is Graph 1 legend color is not consistent with the graph 2 legend color.

    Q:
    Could anyone help me to make the graph 2 legend colors consistent with that of the graph 1, i.e. Legend john’s color should always be maroon, perter should always be green etc. (but manually changing the colors in the graph 2 to make it consistent with graph 1 is not acceptable as I have so many graphs).

    Copying graph 1 to a different place and then re-directing the “data for graph 2” to create the graph 2 is also not acceptable as there are way too many graphs with so many number of legends.

    Thanks
    Mirisa
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,994

    Re: How to make legend color consistent across graphs?

    http://www.thespreadsheetguru.com/th...activeworkbook

    Take a look at this
    Attached Files Attached Files
    Last edited by popipipo; 07-28-2015 at 03:59 PM. Reason: add file
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to make legend color consistent across graphs?

    You need to get into 'format data series' -- Line -- Automatic. Its currently set to Solid line and colour is chosen manually
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to make legend color consistent across graphs?

    Hi popipipo and Ace_XL,

    Many thanks to both of you.

    Best regards

    Mirisa

  5. #5
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: How to make legend color consistent across graphs?

    One other thing you can do is, copy Graph 1

    Select Graph 2, Home tab --> Paste (click the down arrow) --> Paste Special --> Formats

  6. #6
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to make legend color consistent across graphs?

    Hi quekbc,

    Thanks for this idea.

    I will try this too.
    Regards

    Mirisa

+ 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. Replies: 8
    Last Post: 03-26-2015, 07:06 AM
  2. Reverse Sum formula in a cell with a Macro to make column consistent...
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2015, 03:29 PM
  3. Apply consistent color scheme to categories across bar charts in 2013 worksheet
    By RinehartResources in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-23-2014, 12:59 PM
  4. Set chart series color to match series legend entries font color
    By Equipoise in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2013, 07:33 AM
  5. Replies: 1
    Last Post: 10-27-2011, 03:32 AM
  6. Replies: 2
    Last Post: 10-29-2009, 11:51 AM
  7. Excel formula to make AAA-BBB equal to/consistent with BBB-AAA
    By AliceJDavidson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2005, 05:06 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