Interactive charts enable you to explore data more deeply by allowing selectable elements within small multiple charts.
Output selections
It's possible to track any selected element of a small multiple chart. This includes an axis element, an individual chart, or any data point in the chart. This information can be outputted to many Excel cells. Other parts of the report, similar grids, and formulas, can be based on what is in these cells. The chart will also highlight which chart or data point is selected.
These output properties are configured in the properties for the chart control. To track an element, select the relevant checkbox and choose the desired output cell.
The Link to option is also available. This lets you move the focus to another part of the report based on your chosen chart or chart element.
Zoom in on charts
Charts can be zoomed in on to highlight areas of interest. This is set in the chart's properties. The area to zoom in on is selected either on a slider or mini-chart below the main chart or directly on the chart area.
If a zoom mode has been set. For example, you can reset the zoom and zoom out completely by using the button next to the zoom control on a slider or mini-chart. If zoom on charts is enabled, the zoom can also be reset by single-clicking on the chart area.
