Procedure
- Select a cell of the crosstab you want to visualize in a chart.
By inserting a chart with
Analysis, the data of the entire
crosstab is visualized in the chart. If you want to visualize only a subset of
the crosstab data, you can use Microsoft Excel functionality.
If you change the data displayed in the crosstab, e.g. with a filter, the
chart is adapted automatically.
- Choose in the ribbon.
The chart is
added to the analysis. You can position it in the worksheet using drag and
drop.
- Modify the chart.
To modify the chart, you can
use Microsoft Excel options for charts. For example, you can change the chart
type or define a data range for the chart.
- You can move the chart to another
worksheet in the workbook.
On the
Component
tab in the design panel, select the chart you want to move, and open the
Move to
dialog. Select the sheet that should contain the chart and press
OK.
Results
The chart is added to the analysis according to
your configuration. The chart is updated automatically when you change the
displayed data in the crosstab.