+ Reply to Thread
Results 1 to 2 of 2

Consistent colors

  1. #1
    Registered User
    Join Date
    06-04-2015
    Location
    Never Land
    MS-Off Ver
    MS Office 365
    Posts
    4

    Consistent colors

    This may be simple, or impossible. I'm creating multiple line charts all on the same page, so that it is easy to see comparisons from year to year.
    I want the same color themes on all the charts. So I selected the same theme, but it doesn't make the lines the same color. In other words I have three lines on data on each chart. The same three lines of data. I want them to be the same corresponding colors on each sheet. So if monthly income is green, daily, blue, and validations yellow, I want that same scheme on all the charts. That's not what's happening when I select the same theme for each. Is there a way to do this? or a way to select each line and choose that color to make it?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Consistent colors

    Hi,

    Is it an option to create one chart formatted as necessary, then copy and paste it as many times as necessary and then edit each one changing the source data ranges.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Change bar chart colors to be consistent with another chart
    By Larry.LeBlanc@O in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-17-2014, 08:26 PM
  2. Replies: 1
    Last Post: 08-01-2014, 10:33 AM
  3. Keeping the colors of pie chart slices consistent
    By BarryKSC in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-31-2014, 01:01 PM
  4. Replies: 3
    Last Post: 08-08-2008, 06:12 AM
  5. Consistent Colors for Pivot Charts
    By zasskar in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-15-2008, 11:22 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