Help me get started with charting, Access 2003

  • Thread starter Thread starter Margaret Bartley
  • Start date Start date
M

Margaret Bartley

I can't seem to find any introductory material on charting.

I want to chart this recordset (fields go to December):
Yar Jan Feb Mar Apr
---- ------ ------ ------ ------
1996 1,345 4,355 456 989
1997 5,656 934 1,344 2,233

I want a line chart: two lines, one for each year, with 12 data points, one
for each month, and the y axis is the quantity, 0 to 6,000.

I can't figure out how to use the wizard to generate such a chart.

It says there's a limit of 6 fields, and it includes the Year, and each of
the months as separate fields so I can only select to May.

I've tried every combination I can think of, using the wizard, and cannot
get a clue, and the Help file is pretty useless.

Any suggestions for tutorials?

Many thanks.
 
Try this layout for your record source:
Year Month Amount
----- ------- ---------
1996 Jan (or 01 is better) 1,000
1996 Feb (02) 2,500
....
1997 Jan (01) 3,000 and so on
 
Back
Top