Charting problems

[neilw71]

I need to create a chart to show Actual Sales vs Budget Sales for a group of Companies.

I have Act Sales by month in one Table and Budget Sales by month in another Table. I have created a query to combine that data with 4 columns:

Month - Company - Act Sales - Budget Sales

Here I run into my problem - how do I chart that data? I have tried with a Pivot Table as well without success. Previously in Excel, I could just add in the data series, but can not see that option offered anywhere.

I am using Access 2000 and have tried on machines with Excel 97 and 2000

Thanks for any tips

Neil