Greetings,
I need to create a report that displays a few pages worth of scatterplots (4 pages with 2 plots per page).
I'll be honest, the pivotchart view really gets on my nerves (same with the "insert chart"). I'm hoping it is do to my own incompetence. All I want to do is display x,y data. x = date, y = lab result value. The pivotchart wants to summarize these values by month, year, etc... I don't want the values to be summarized by date in any way. I simply want the x-axis labels/tics to be in 1 month increments (showing mm/yy) BUT not have the y values summarized within these intervals (just show me the raw values).
Also, the aesthetic quality of these graphs made within Access is not appealing. The resolution of the image appears very low (I can see pixels with my naked eye at 1:1 zoom). These reports are being printed so I would like a screen resolution that can be printed at 300dpi quality.
1. Should I be making these graphs in Access. The greatest benefit of doing this is that it appears to be the least complicated route.
2. If yes to 1, how can I get past the current downfalls I am experiencing.
3. If no to 1, what method should I use? I can envision using creating an automated routine where each particular query for each graph is exported to excel, the graph is made in excel, and then inserted into a word document or access report. Does the access report have any resolution limitations? If so I would use word to make the report. Using these different applications will be more work but I know my way around Excel and won't have to deal with pivotcharts, which as far as I can tell are completely useless for simple x y scatterplots.
Any responses are greatly appreciated - based on what I have read on other posts on this topic it seems to be a very unpopular issue for database creators/managers.
I need to create a report that displays a few pages worth of scatterplots (4 pages with 2 plots per page).
I'll be honest, the pivotchart view really gets on my nerves (same with the "insert chart"). I'm hoping it is do to my own incompetence. All I want to do is display x,y data. x = date, y = lab result value. The pivotchart wants to summarize these values by month, year, etc... I don't want the values to be summarized by date in any way. I simply want the x-axis labels/tics to be in 1 month increments (showing mm/yy) BUT not have the y values summarized within these intervals (just show me the raw values).
Also, the aesthetic quality of these graphs made within Access is not appealing. The resolution of the image appears very low (I can see pixels with my naked eye at 1:1 zoom). These reports are being printed so I would like a screen resolution that can be printed at 300dpi quality.
1. Should I be making these graphs in Access. The greatest benefit of doing this is that it appears to be the least complicated route.
2. If yes to 1, how can I get past the current downfalls I am experiencing.
3. If no to 1, what method should I use? I can envision using creating an automated routine where each particular query for each graph is exported to excel, the graph is made in excel, and then inserted into a word document or access report. Does the access report have any resolution limitations? If so I would use word to make the report. Using these different applications will be more work but I know my way around Excel and won't have to deal with pivotcharts, which as far as I can tell are completely useless for simple x y scatterplots.
Any responses are greatly appreciated - based on what I have read on other posts on this topic it seems to be a very unpopular issue for database creators/managers.
