I have a database that tracks the lab testing that my employees perform on a daily basis. This data is divided first by Type(XP-**). Each of which is subject to a battery of tests (8 tests). MY boss wants a monthly report that lists all of the types of foam tested in the last month with some indicator of where the last testing data falls in relation to the trend for that material over the last year. I currently have the data base set up to generate a full set of graphs for each type of material (inside Access), which is not ideal for given general trend info to management. Its far to clunky to print or even email as the data is pulled directly from the database to generate the report.
I am hoping for some ideas on how to better present this data and the trend in each type/test result. Is there some way to plot the changes in each test results in a single graph?