Hi

I saw somewhere that within a chart, you can have conditional formatting. Such that when the data point is above mean its "green" and when its below mean its "red".



Can someone help me with that. I have attached a sample that you can use

Thx in advance

Attached Files

conditional chart.xlsx (13.4 KB, 11 views)

Hi
you will certianly find help at Jon Peltier's site

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thx I looked but he only has bar graphs, not line graphs

There are line charts on this page

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post