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!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Day 1[/TD]
[TD]Day 2[/TD]
[TD]Day 3[/TD]
[TD]Day 4[/TD]
[TD]Day 5[/TD]
[TD]Day 6[/TD]
[TD]Day 7[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]110[/TD]
[TD]95[/TD]
[TD]85[/TD]
[TD]105[/TD]
[TD]100[/TD]
[TD]115[/TD]
[/TR]
</tbody>[/TABLE]
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!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Day 1[/TD]
[TD]Day 2[/TD]
[TD]Day 3[/TD]
[TD]Day 4[/TD]
[TD]Day 5[/TD]
[TD]Day 6[/TD]
[TD]Day 7[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]110[/TD]
[TD]95[/TD]
[TD]85[/TD]
[TD]105[/TD]
[TD]100[/TD]
[TD]115[/TD]
[/TR]
</tbody>[/TABLE]