+ Reply to Thread
Results 1 to 3 of 3

Coloring excel line graph based on X-axis value

  1. #1
    Registered User
    Join Date
    01-14-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    2

    Coloring excel line graph based on X-axis value

    Hello everyone,

    I have a graph in excel where the Y-axis shows the temperature in celsius and the X-asis the time.
    I would like to change the color of the graph base on the time. For example I want the line to be green from 14:02 untill 20:00.
    I try to google for a way to accomplish this, but the closest thing I could fint was coloring the line based on the Y-axis value.
    Is wat I want even possible in Excel? if so can someone walk me through the steps to get this done? or point me in the right direction.

    Many thanks in advance,
    Jason
    Attached Images Attached Images

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

    Re: Coloring excel line graph based on X-axis value

    You need a extra column
    Attached Files Attached Files
    Last edited by popipipo; 01-14-2021 at 08:02 AM. Reason: edit second graph
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    01-14-2021
    Location
    London
    MS-Off Ver
    2016
    Posts
    2

    Re: Coloring excel line graph based on X-axis value

    Thank you very much

+ 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. Line graph with 2 y-axis not showing correct x-axis labels
    By TheRobsterUK in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2020, 12:15 PM
  2. changing axis in line graph - label axis should be on y-axis
    By Falimus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2020, 04:56 PM
  3. Replies: 7
    Last Post: 10-23-2014, 07:01 PM
  4. THIS IS PROBABLY SUPER EASY...Excel Line Graph X-axis scaling!!!
    By aillc825 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-09-2014, 04:47 AM
  5. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  6. Y axis issues for line graph - Excel 2010
    By noob99 in forum Excel General
    Replies: 2
    Last Post: 06-08-2012, 11:00 PM
  7. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 PM

Tags for this Thread

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