Access Report - Custom Stacked Line Chart (1 Viewer)

[rexcision]

Wondering if someone can point me in the right direction. I am updating an access db and one of the reports that gets used a lot is for displaying sieve data. I have attached an example of the current charts output here. The chart is an embedded Microsoft Graph 97 Chart and was created by an employee who is no longer here in the late 90's or early 2000's. An issue has been creeping up over the past few years where more and more of our systems output the chart like the second image I have attached, so the formatting of this chart is hit or miss and people are requesting other people to print things for them so it formats correctly. Note the two images are the same report but printed on different computers. I'm assuming it has to do with the Access version, but I don't really have control over which version people get installed on their systems. So I am wondering if anyone has dealt with something like this before, or if anyone has any insight into how I can create a similar chart but with more modern technology so formatting will be better.

From what I can tell though, Access doesn't have anything to easily create the graph I want or at least that I am aware of so wondering if anyone has any idea where I should look. Does access have the ability to generate graphs with additional features through VBA? or is the property sheet and chart settings all there are? or are there other options I may not be aware of?

 

[Mike Krailo]

It's also possible some users just don't have their print settings setup properly. For instance, here are settings on my HP printer. If the Resizing Options are set differently on someone's computer, it could cause anything printed to be skewed. Of course your printer may not have these settings, but you can check and see.

 

[June7]

I also had to build a chart for sieve data. I use classic MSGraph, not Modern Chart. Vertical lines are line controls overlying chart and x-axis labels are textboxes with Vertical property set to Yes. Label controls also have Vertical property but I needed to have expression to display metric or english based on criteria.