If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
(y) secondary axis in Access Chart
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. |
#2
|
|||
|
|||
(y) secondary axis in Access Chart
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/assistan...030882441033&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. |
#3
|
|||
|
|||
(y) secondary axis in Access Chart
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. Thanks in advance for help on this. . |
Thread Tools | |
Display Modes | |
|
|