Chart formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan Johnson - 27 Jan 2007 21:10 GMT

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.

Signature

Dan Johnson

Reply to this Message

Duane Hookom - 28 Jan 2007 15:36 GMT

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.

Signature

Duane Hookom
Microsoft Access MVP

> 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.
>
[quoted text clipped - 3 lines]
>
> Thanks for any advice.

Reply to this Message