Chart formatting

[Dan Johnson]

Is there a means to have a chart such that a value below a given value is one color and above another value. I am trying to format the chart to show values above $500.00 to display in red and those below in green.

I have the chart and have tried several different types of charts but no luck in having more than one color. I have a line chart with the Y axis crossing at $500.00 and this looks acceptable but the colors would give much more effective with those under as described above.

Doing this in SQL will be rather impossible because I am totally inept at using SQL.

Thanks for any advice.

 

[Duane Hookom]

The only solution that I can think of is to divide your data into to two
"dataset". For instance, change your chart's Row Source to something like:
SELECT SalesDate,
IIf([Sales]>=500,[Sales],Null) as HigherSales,
IIf([Sales]<500,[Sales],Null) as LowerSales
FROM tblSales
ORDER BY SalesDate;

This should create two lines that can be colored separately.