I have been working with an area chart colored in green. Based on certain
values of the graph, I would like the area just below the data point
highlighted in a different color (like red). In the end, the area graph will
have 2 different colors in the 'area' below the line. The color below, will
depend on the value of the line above. Any help is appreciated.

Also, I would consider a vertical bar graph where the spacing in between
bars is zero. That way, from a far, it could give the appearance of an area
graph. I think I would need each 'bar' colored appropriately. I have
struggled coming up with this graph as well.

I envision a 3 column data series...
Column A = x axis
Column B = y axis
Column C = logic calculation that determines whether the data point is
colored red or green.

I am open to suggestions and assistance.