chart Q

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Hi, I want to include a chart in my report that uses two Y-
axis. For instance, the X-axis is the same for two
different variables that I want to plot. I would like one
set of values on the left side of the chart and another
set of values on the right side of the chart. Then plot
two variables using different markings. I know you can do
this in QuatroPro, but I don't know if you can do it in
Access. Can anyone help me here?
Thanks,

Adam
 
I don't think Access has a Chart option for 2-Y axis.

I usually work around this by having two charts side by side. Y axis #1 as
left chart and Y axis #2 as right chart. Usually I just do chart 1 first,
then duplicate it and substitute data for chart 2, so that both charts are
the same size.

Hope this helps.

Cameo
 
You can have two Y scales. I always build charts on forms and set
Enabled=Yes and Locked = No. Then view the form and double-click the graph
to open it. You can then set properties for the second Y axis/scale.
 
Back
Top