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.