Results 1 to 2 of 2

Thread: Conditional Formating Chart Points
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2018
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Formating Chart Points

    A B C
    1 Item1 -2 Station25
    2 Item2 -5 Station26
    3 Item3 -7 Station27
    4 Item1 -8 Station28
    5 Item3 -10 Station29
    Hello,

    I need help please.
    I have been searching the internet and cannot find this solution.
    Column B is plotted on a chart as points.
    I need the Item1 points to be Yellow, Item2 points Blue, Item3 points Red.
    The list must be in a mixed order shown and cannot be sorted.
    Column C is the Horizontal Axis.
    The Vertical Axis is a scale for the Column B numbers.

    Thank you,
    B

  2. #2
    Board Regular
    Join Date
    Aug 2018
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formating Chart Points

    Here is an example of what I am trying to achieve.
    The conditional colors need to be dynamic so as the data changes the colors change with it.
    Colors cant be hard coded.


Some videos you may like

User Tag List

Tags for this Thread

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
  •