[RESOLVED] Graphs in Microsoft Access

[nagasrikanth]

Hi all,

Can any one of you tell me how to add a target line to a chart..
Let me explain clearly whats my problem was..

I had a form in which user will select 2 dates(From date,todate).By using this i will run some queries which will give input to the Graph which is there in the same form..
Till now i dont have any problem.Now the requirement is I need to show a Target line in the graph which will be standard forever..
I think,I had explained my problem correctly..
Please help me ...

Thanx & Regards
Srikanth...

[DKenny]

Srikanth

You will need to add a second series to your chart data.
As you are using a query to get the chart data and the target line is a fixed value, you could just add a new column to the query with a fixed value to represent the target.
e.g. SELECT ..all your current fields...,42 AS Target FROM yourtable etc

Assuming that 42 is the target, this will add a column to your dataset with 42 on each row. Now all you have to do is add a new dataseries to your graph - using this column as the source.

[nagasrikanth]

Gr8....Its worked, Kenny...u did it..
ThaQ so muchh..