Hello All,
I'm looking for a way to conditional format each segment of a line chart. Basically, if the segment is positive (from a lower point to a higher point) I want to the segment to be green. If the segment is negative ( higher point to a lower point) I want to the segment to be red. Any thoughts. All help is sincerely appreciated!
<tbody>
</tbody>
I'm looking for a way to conditional format each segment of a line chart. Basically, if the segment is positive (from a lower point to a higher point) I want to the segment to be green. If the segment is negative ( higher point to a lower point) I want to the segment to be red. Any thoughts. All help is sincerely appreciated!
Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 |
100 | 110 | 95 | 85 | 105 | 100 | 115 |
<tbody>
</tbody>