Show TOC

To insert a dynamic chartLocate this document in the navigation structure

Procedure

  1. 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.
  2. Choose Start of the navigation path Chart Next navigation step Insert Chart End of the navigation path in the ribbon.
    The chart is added to the analysis. You can position it in the worksheet using drag and drop.
  3. 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.
  4. 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.