Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    colour chart line based on value (2002 SP3)

    Hi,

    Is it possible to have a line in a chart change colour based on the value?
    eg I have a target of 50 claims per month. If we receive less than 50 per month it is good and could be coloured green, however if we receive more than 50 then it is bad and could be coloured red.

    Generally I have a chart, with a solid line representing the target (covering 24 months), and the line representing the claims may rise above or sink below this line. I've built a dashboard with 10 different targets and although it looks good, it's difficult to quickly see which results should be below the target line and which results should be above. If I could colour the results green and red then the viewer could tell at a glance where the good perfromances were.

    Thanks for any help or suggestions.
    capri

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: colour chart line based on value (2002 SP3)

    See the thread starting at <post:=626,857>post 626,857</post:>. Several examples are attached there.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: colour chart line based on value (2002 SP3)

    Thanks Hans,

    That's exactly what I was looking for.

    capri

Posting Permissions

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