I have a table with data about the number of accurences of a specific event. This table has 5 columns: Amount, Month, Year, Area and MsgType. From this table I would like to make a graph representing the following:
X-Axis: Month
Y-Axis: Amount
Lines: MsgType
The graph will get multiple lines, one for each Type. This way you get an overview of how the amount of events over a few months went up or down. Furthermore I'd like to have one graph for each area (5 in total, each having the same layout, as described above). Year doesn't really have anything to do with the graphs, but I use it on the form to specify which month/year the report is from.
I tried the wizard but it doesnt really give me the result I need. Furthermore, my knowledge about graphs in Access is very little. That's basically why I came here to ask for help.. Does anyone know how I can do this? (If you need more info, say so, that way I can post the stuff you need..)
X-Axis: Month
Y-Axis: Amount
Lines: MsgType
The graph will get multiple lines, one for each Type. This way you get an overview of how the amount of events over a few months went up or down. Furthermore I'd like to have one graph for each area (5 in total, each having the same layout, as described above). Year doesn't really have anything to do with the graphs, but I use it on the form to specify which month/year the report is from.
I tried the wizard but it doesnt really give me the result I need. Furthermore, my knowledge about graphs in Access is very little. That's basically why I came here to ask for help.. Does anyone know how I can do this? (If you need more info, say so, that way I can post the stuff you need..)