+ Reply to Thread
Results 1 to 5 of 5

making different parts of series chart different color

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    making different parts of series chart different color

    Hello. If I have a line chart with dates, how can I make different years, different colors?

  2. #2
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: making different parts of series chart different color

    Hello Amma,

    Go to your line chart, click on line then click again on line, a particular year will be selected now and now you can format accordingly.

    Line Chart Color.PNG
    Thanks,
    Anil Dhawan


    Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.

    Don't stop when you are tired. STOP when you are done!

  3. #3
    Registered User
    Join Date
    02-25-2014
    Location
    Brisbane
    MS-Off Ver
    Excel 2000
    Posts
    78

    Re: making different parts of series chart different color

    Usually if you right click on the line itself in the graph and select Format data series it will let you change
    the colour of that line?

    Menu.JPG

    Menu2.JPG

  4. #4
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: making different parts of series chart different color

    If you face any problem, follow the below steps.


    Select On line of the chart. (See Below).
    Chart Line Color 1.png

    Then try to select particular any year by doing another click (See as I have selected 2019)
    Chart Line Color 2.png

    Do right click now, and go to Outline to change the color of the line.
    Chart Line Color 3.png

    Here you go, You are now done. (I am also done as i have changed the 2019 year line to Red).
    Chart Line Color 4.png

    Hope this will make you more clear.

    Cheers!!!


    Anil

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

    Re: making different parts of series chart different color

    depending on the criteria for line colour you could just use the "Vary colors by point" option.

    Format line, Marker fill, Vary colors by point.

    Note you do not need to have a marker displayed.
    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. 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
  2. Bubble Chart - Different color per series
    By Nadine Klug in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 09:51 AM
  3. Help on making a chart with cells no value but fill color only -
    By nolivy in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-23-2012, 07:28 AM
  4. Format color of Series in a chart
    By ekomsky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2012, 04:00 PM
  5. changing series color within a chart
    By lmigarci in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-03-2008, 02:00 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