(y) secondary axis in Access Chart

[Guest]

Hopefully this is an easy question with an easy answer and it is just user error/ignorance!

My question: Can a secondary (y) axis be created on a chart in Access? I am able to do this in Excel but have not been able to fiqure this out in Access

Thanks in advance for help on this

 

[Raghu Prakash]

Hi Michelle,

I am not sure this would help...but please take a look at
Add, remove, or change axes in PivotChart view
http://office.microsoft.com/assistance/preview.aspx?AssetID=HP030882441033&C
TT=1&Origin=EC790000701033&QueryID=cfY5XGnfW&Query=Add%2c+remove%2c+or+chang
e+axes+in+PivotChart+view&Scope=TC%2cHP%2cHA%2cRC%2cFX%2cES%2cEP%2cDC%2cXT

Open a datasheet or form in PivotChart view (PivotChart view: A view that
shows a graphical analysis of data in a datasheet or form. You can see
different levels of detail or specify the layout by dragging fields and
items or by showing and hiding items in the drop-down lists for the
fields.).
Click the chart workspace (the blank area between the plot area and the
chart boundary).

On the PivotChart toolbar, click Properties , and then click the Series
Groups tab.

Under Series groups, in the Select one or more series box, select the
series group for which you want to add an axis.

If you want the axis to reflect a different series, you can group, ungroup,
or merge series with other groups.

Under Add axis, in the Groups box, select the group that you want to add
the axis for, and then in the Axis position box, select where you want the
axis to be displayed.

Click Add.

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Van T. Dinh]

Both Excel and Access use the same Microsoft Graph to
create charts so if you can do it in Excel, you can do it
in Access (actually, you create / modify the secondary y-
axis in MS Graph).

Double-click on the Chart Object and it will be opened in
MS Graph and you should have the same Menu as when you
modify the chart "in Excel".

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
Hopefully this is an easy question with an easy answer

and it is just user error/ignorance!

My question: Can a secondary (y) axis be created on a

chart in Access? I am able to do this in Excel but have
not been able to fiqure this out in Access.