B
BlockNinja
I am trying to make a dynamically populated chart in Access on a form where
users can enter in a criteria then the chart's rowsource will be changed to
query on the data that it needs. My data that is fed into the rowsource
looks something like this:
(STLM = Same Time Last Month)
Date ForecastedOrActual CurrentDollars STLMDollars
12/1/05 Actual $3291083 $219038
12/2/05 Actual $3291033 $219538
12/3/05 Forecasted $3291053 $219288
The forecasted values were pre-processed from other queries, and I have all
the correct information that I want there. What I want to be able to do is
have a chart that shows the following:
The date, whether it is forecasted or actual (right now I combine the 2 into
one string field for the rowsource so the output looks like "12/1/05 - A,
12/2/05 - A, 12/3/05 - F" for easy representation), then a series for the
Current Dollars, and a series for STLM Dollars to show for comparison. What
I would like to be able to do is have the Current Dollars show Blue for
Actual Values and Purple for Forecasted. Is it possible to do this with the
Chart object? I can't find a property anywhere in the object to let me do
this. Also, the object comes in as OLE, so the user could just as easily
edit the chart, which is something that I don't want them to be able to do.
Any ideas?
users can enter in a criteria then the chart's rowsource will be changed to
query on the data that it needs. My data that is fed into the rowsource
looks something like this:
(STLM = Same Time Last Month)
Date ForecastedOrActual CurrentDollars STLMDollars
12/1/05 Actual $3291083 $219038
12/2/05 Actual $3291033 $219538
12/3/05 Forecasted $3291053 $219288
The forecasted values were pre-processed from other queries, and I have all
the correct information that I want there. What I want to be able to do is
have a chart that shows the following:
The date, whether it is forecasted or actual (right now I combine the 2 into
one string field for the rowsource so the output looks like "12/1/05 - A,
12/2/05 - A, 12/3/05 - F" for easy representation), then a series for the
Current Dollars, and a series for STLM Dollars to show for comparison. What
I would like to be able to do is have the Current Dollars show Blue for
Actual Values and Purple for Forecasted. Is it possible to do this with the
Chart object? I can't find a property anywhere in the object to let me do
this. Also, the object comes in as OLE, so the user could just as easily
edit the chart, which is something that I don't want them to be able to do.
Any ideas?