none
Pivot Chart in Data Analysis view 2007 RRS feed

  • Question

  • Hi,

    I have a Pivot Chart with 2 vertical axis : Value Axis1 and Value Axis 2. I'm trying to set 2 different scales, but if I change the scale of axis 1, the scale of axis 2 changes the same way. And reverse order.

    How to dissociate the 2 axes ?

    Thanks

    Friday, March 2, 2012 1:21 PM

Answers

  • WLID1966 --
     
    Wow, this is a hard one.  For my research, I created a simple Data Analysis view called Project Work and Cost.  I will ask you to do the same to learn how to add a secondary Y axis.  Please try the following steps in this simple Data Analysis view so that you can apply the knowledge to your own view:
     
    1.  Create a new Data Analysis view called Project Work and Cost and base it on the MSP_Portfolio_Analyzer cube.
    2.  Add the Project List dimension to the Row Fields drop area; add the Work and Cost total fields to the Total Fields drop area (make sure the Cost field is on the right of the Work field).
    3.  Select the Show Field List and Show Toolbar options as well.
    4.  Click anywhere in the PivotChart to select it.
    5.  Click the Chart Type button at the left end of the PivotChart toolbar.
    6.  In the Commands and Options dialog, select the Line chart type and select the second item in the first row (line with markers).
    7.  Select the General tab in the Commands and Options dialog.
    8.  Click the Select pick list in the middle of the General page and select the Chart Workspace item on the list.
     
    The system will redisplay the dialog with additional tabs across the top.
     
    9.  Select the Series Groups tab.
    10.  In the Select One or More Series list, select the Cost item and then click the OK button on the right side of the line.
     
    The dialog should refresh to show Cost data as group 2.
     
    11.  In the Add Axis section at the bottom of the dialog, select the 2 item in the Groups list.
    12.  Click the Axis Position pick list, select the Right item, and then click the Add button.
     
    You should now see a secondary Y axis on the right side of the PivotChart.  From here, you can return to the General page of the dialog, click the Select pick list, and select either Value Axis 1 or Value Axis 2 and then format those axes according to your own specifications.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    • Marked as answer by WLID1966 Friday, March 2, 2012 4:08 PM
    Friday, March 2, 2012 2:46 PM
    Moderator

All replies

  • WLID1966 --
     
    Wow, this is a hard one.  For my research, I created a simple Data Analysis view called Project Work and Cost.  I will ask you to do the same to learn how to add a secondary Y axis.  Please try the following steps in this simple Data Analysis view so that you can apply the knowledge to your own view:
     
    1.  Create a new Data Analysis view called Project Work and Cost and base it on the MSP_Portfolio_Analyzer cube.
    2.  Add the Project List dimension to the Row Fields drop area; add the Work and Cost total fields to the Total Fields drop area (make sure the Cost field is on the right of the Work field).
    3.  Select the Show Field List and Show Toolbar options as well.
    4.  Click anywhere in the PivotChart to select it.
    5.  Click the Chart Type button at the left end of the PivotChart toolbar.
    6.  In the Commands and Options dialog, select the Line chart type and select the second item in the first row (line with markers).
    7.  Select the General tab in the Commands and Options dialog.
    8.  Click the Select pick list in the middle of the General page and select the Chart Workspace item on the list.
     
    The system will redisplay the dialog with additional tabs across the top.
     
    9.  Select the Series Groups tab.
    10.  In the Select One or More Series list, select the Cost item and then click the OK button on the right side of the line.
     
    The dialog should refresh to show Cost data as group 2.
     
    11.  In the Add Axis section at the bottom of the dialog, select the 2 item in the Groups list.
    12.  Click the Axis Position pick list, select the Right item, and then click the Add button.
     
    You should now see a secondary Y axis on the right side of the PivotChart.  From here, you can return to the General page of the dialog, click the Select pick list, and select either Value Axis 1 or Value Axis 2 and then format those axes according to your own specifications.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    • Marked as answer by WLID1966 Friday, March 2, 2012 4:08 PM
    Friday, March 2, 2012 2:46 PM
    Moderator
  • Thanks a lot Dale,

    I think I missed "select the Right item, and then click the Add button" in my previous trials.

    Friday, March 2, 2012 4:11 PM
  • WLID1966 --
     
    Alas, missing one small step can create a BIG nightmare!  :)  You are more than welcome for the help, my friend.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, March 2, 2012 4:19 PM
    Moderator