Help creating chart

[gnb621]

I have a query which generates the following result:

Example:
Material ProdID Nov. Dec. Jan. etc
Container 123 6 5 6 2
Container 578 3 5 8 12
Fin. Good 598 1000 1000 66 656
Raw Mat. 565 526 6598 656 0
etc....

I can set up a summary report that gives me totals per month per Material type:
ex. nov. dec. jan. etc.
Container 9 10 14 14
Fin. Good 1000 1000 66 656
Raw Mat. 526 6598 656 0

I need to graphically display the results but don't know houw. I used the chart wizard but it charts all the records from my query.
I need help on what to do next.

 

[GingerR]

make your query a TOTALS query (VIEW+TOTALS)
omit field ProdID and assign GROUPINGS as such:

Material NOV DEC ETC
GROUP SUM SUM SUM

To make a chart (this is long, but not hard, so hang in there):
1. click once on your query
2. click to make a report, choose CHART WIZARD
3. go thru the wizard, doesnt matter what you choose cause we're gonna change it anyhow
4. once the wizard is done, what you see is your resulting chart. it is small.
a) go to design of the report
b) right-click on the chart and view PROPERITES
c) change SIZE MODE to STRETCH. now you can alter the size of your chart by clicking on corners or sides of it and stretching it around.
5. in design of the chart, Access shows i.e. North South East West--it's their template for the data. let's get rid of that:
a) go to your query that the report is based on, and run it.
b) use keyboard ctrl+a (select All), then copy (ctrl + c). close the query.
c) go back to design of the report. double-click on the chart, this brings it to design of the chart. if you cannot see it already, go VIEW+DATASHEET. click in upper-left hand corner, and go ctrl+v (PASTE). this puts in YOUR data as the template data. now in design mode of the chart, you can see what your stuff will actually look like. from here, if you are familiar with Excel, you can do similar things: change colors of lines, change chart type (line, column, etc) add titles, change fonts and colors. to do each of those things, just right-click on whatever it is you want to change (an axis, or a line) and choose from the drop-down menu. or look on the menu selections for formatting and other chart options.

the data in the chart will change if your query changes. this is just a way to design your chart.