Results 1 to 5 of 5

Is it Possible to Conditionally Format a Line Graph?

This is a discussion on Is it Possible to Conditionally Format a Line Graph? within the Excel Questions forums, part of the Question Forums category; Good morning, I have a line graph that has varying levels of slopes. I was wondering if there was a ...

  1. #1
    New Member
    Join Date
    Jan 2015
    Posts
    12

    Default Is it Possible to Conditionally Format a Line Graph?

    Good morning,

    I have a line graph that has varying levels of slopes. I was wondering if there was a way to conditionally format the line to show more green the more the slope is flat, show more red when the slope is very steep, and yellow/orange when it's about halfway in between. Is this possible?

    Thank you in advance!

    Cory

  2. #2
    Board Regular
    Join Date
    Jul 2014
    Location
    The Netherlands
    Posts
    997

    Default Re: Is it Possible to Conditionally Format a Line Graph?


  3. #3
    New Member
    Join Date
    Jan 2015
    Posts
    12

    Default Re: Is it Possible to Conditionally Format a Line Graph?

    Unfortunately, that's not going to work. I saw that before but it needs to be dynamic. Any other suggestions?

  4. #4
    Board Regular
    Join Date
    Jul 2014
    Location
    The Netherlands
    Posts
    997

    Default Re: Is it Possible to Conditionally Format a Line Graph?

    maybe but will need a sample of your data to play with to check if my idea works.

  5. #5
    New Member
    Join Date
    Jan 2015
    Posts
    12

    Default Re: Is it Possible to Conditionally Format a Line Graph?

    Here's an example of what it could look like:

    Player A - 108.4
    Player B - 106.8
    Player C - 102.0
    Player D - 99.9
    Player E - 86.4
    Player F - 86.2
    Player G - 86.1
    Player H - 84.1
    Player I - 78.1
    Player J - 77.9
    Player K - 76.8
    Player L - 74.0
    Player M - 69.8
    Player N - 69.4

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com