Secondary Axis on Line Chart

[a.t.brooks]

Hi Guys,
I posted this a week ago, but it seems to have vanished from the
board!

Is it possible to plot two data sets on the same line graph with
different scales? i.e. Have a secondary axis, like in Excel?

I have one dataset fluctuating around 2.0 over time and another
dataset fluctuating around 50 over time.
If I plot both of these in the same graph, I lose the subtle changes
in the first dataset.
I can sort of bodge it by writing a query with an expression to
multiply the first dataset by 25, but then I can't get the "real"
values to show on the axis.

I find the graph function in Access very infuriating. Why can't they
just allow yout the same features as in Excel?

Thanks for your help (if anyone can solve this one)

Tony

 

[Rob Parker]

Hi Tony,

I saw your earlier post, but was too busy to reply (and figured someone else
would answer anyway). But they didn't, and even this post has been up for
about 17 hours, so ...

Yes, it's possible. And it's essentially the same things that you'd do in
Excel - the graph engines are very similar (possibly identical in some
versions of Office). Really, the only tricky bit is getting to the chart to
set things as you want. So, with your report (or form, but I'm assuming
that your chart is in a report, since you've posted to the reports group)
open in design mode, double-click the chart object to enter edit mode for
the chart itself. The menubar will change to include several charting
menus, chart toolbars will appear, and chart right-click menu will be
available. Alternatively, with the chart object selected, select
ChartObject - Edit from the right-click menu to open the graph applet in a
separate window.

The simplest way to convert to a two-axis chart is probably just to select
it via Chart Type on either the Chart menu or via the right-click menu;
several 2-axis options are available on the Custom Types tab. With only two
datasets in your recordsource, you won't need to do any adjustment to set
which dataset is on which axis. An alternative method is to click on one of
the data series lines in the chart, then from the Format Data Series menu,
select Secondary axis on the Axis tab.

You can, of course, select any chart item and format it as you want, exactly
as when working with a chart in Excel.

HTH,

Rob

 

[a.t.brooks]

Cheers Rob,
It works a treat!