4 Replies Latest reply: Mar 3, 2014 12:03 AM by Sebastian Pereira RSS

    How to you stop a horizontal chart from exporting to Excel horizontally?

    Richard Blakemore

      Hi

      I have created a table chart to approximate a Profit & Loss Statement.

      Horizontal 2.JPG

      The dimension is financial periods, and to represent this dimension as columns with the expressions running in rows down the page, Horizontal 1.JPG

      I had to tick the Horizontal box on the Presentation tab in Properties.


      Unfortunately, when the chart exports to excel, the periods return to rows, and the expressions become columns.

      Horizontal 3.JPG

      Any idea on how to force QV to export it as per the chart object displays?

       

      Cheers