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