Question Ms Access 2007 Graph 2 fields

[pekajo]

Hi,
I think the answer will be very simple but I can only seem to graph one field using the Graph wizard. I have a table that have running totals:
Date-----Sales ---- Budget
1/8/2013 0 2000
2/8/2013 2500 4000
3/8/2013 2500 6000
4/8/2013 4000 8000

I can only seem to chart the first column after the date. Can someone tell me what I am missing?

Thanks for any help
Peter

 

[Mihail]

Maybe this article is a help for you.

 

[pekajo]

Hi,

Thanks for your help. I figured it out this morning.
Edited the properties and added the extra field to the Query.

Thanks again
Peter