locked
PPS analytic chart (bar chart) stretched vertically to horizontally RRS feed

  • Question

  • Hi, all,

     

    Just wondering if anyone knows if we can flip the PPS analytic chart (bar chart) stretched vertically to horizontally. As to from -

     

     

    To -

    As we know this is not what ‘Pivot’ function does in the chart. I mainly just need to pivot turn the chart 90 degree (with the turned legends, of course), instead of pivot the dimensions in the chart design.

     

    Can we do it? Thanks in advance.

    • Moved by Mike Walsh FIN Monday, February 14, 2011 9:09 AM PPS is not part of MOSS 2007 and is therefore not covered in the pre-2010 SP forums (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    • Moved by Heidi Tr - MSFT Monday, February 14, 2011 5:24 PM wrong queue (From:Planning)
    • Edited by VarunKumar17 Wednesday, February 16, 2011 2:50 AM Added Images
    Monday, February 14, 2011 8:58 AM

Answers

  • Hello,

    There is no way out of the box to flip the entire report.

    Thanks
    Heidi Tr - MSFT


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Wednesday, February 23, 2011 8:50 PM
  • So you want an actual bar chart instead of a column chart.  I think this is what you are after right?  The Analytical Chart report option currently does not have a actual bar chart option (only the column, line, or pie - along with grid).  If you need a bar chart you would have to leverage a different technology and incorporate this into your dashboard like Reporting Services, Excel, or ProClarity.  These other tools have some additional options and flexibility with report types and options that are currently not available in PerformancePoint like area, bar, point, bubble, funnel, scatter, polar, etc.  These additional tools and report options can all be integrated into your PerformancePoint dashboard and provide you the visuals that you are looking for.
    Dan English's BI Blog
    Thursday, February 24, 2011 12:19 PM

All replies

  • Hello,

    Your pictures are not showing up in this form.  So I have some additional questions to get a better idea of what you are trying to accomplish. 

    1.  Are you trying to flip the entire report itself from Vertial to Horizontal?

    2.  OR are you trying to change the direction of the bar chart....so instead of growing out of the bottom axis....the bar chart is coming out of the left hand side?

    Thanks
    Heidi Tr - MSFT

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, February 15, 2011 7:27 PM
  • I am trying to flip the entire report

     

    Wednesday, February 16, 2011 2:51 AM
  • Hello,

    There is no way out of the box to flip the entire report.

    Thanks
    Heidi Tr - MSFT


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Wednesday, February 23, 2011 8:50 PM
  • So you want an actual bar chart instead of a column chart.  I think this is what you are after right?  The Analytical Chart report option currently does not have a actual bar chart option (only the column, line, or pie - along with grid).  If you need a bar chart you would have to leverage a different technology and incorporate this into your dashboard like Reporting Services, Excel, or ProClarity.  These other tools have some additional options and flexibility with report types and options that are currently not available in PerformancePoint like area, bar, point, bubble, funnel, scatter, polar, etc.  These additional tools and report options can all be integrated into your PerformancePoint dashboard and provide you the visuals that you are looking for.
    Dan English's BI Blog
    Thursday, February 24, 2011 12:19 PM