Transposing chart data sources

The Data Source dialog box of charts has options to hold the chart data in rows or in columns. In some types of chart, you cannot change these options after the chart has been created.

In such cases, you have these options:

  • Create a new chart with the required data source orientation and manually implement the correct chart formatting.
  • Transpose the report by changing the report definition so that the column and row headers are switched.

    You can achieve this by changing the direction of the hyperblock and reshaping it. For example, change a hyperblock that occupies cells E4,F4, and G4 and expands vertically, to a hyperblock that occupies cells E4,E5, and E6 and expands horizontally.