I have a need to highlight a date range in a bar chart. If the
"highlighti ng" is accomplished by changing the bar column color for the
specific months in the date range, that would be great.
Here's an example:
I'm plotting meter usage against dates on the chart. The dates are typically
the first day of the month.
So assume the chart range is 1/1/2000 through 10/31/06, but for the date
range 11/1/05 through 10/31/06 I want those columns on the chart to be a
different color than the other bar columns on the chart (1/1/2000 through
10/31/2005).
I thought I could try selecting the two different ranges (1/1/2000 through
10/31/2006 and 11/1/2005 through 10/31/2006) and that that would give me two
different colors (i.e Access would view this as two different series). But it
doesn't seem to be working for one SQL statement. I also tried a Union
Select but that didn't result in different colors being shown.
The chart RowSource property is to be set to an SQL statement in code.
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200611/1