Analyzing data with the design panel

The Analysis design panel is an additional element on the user interface that you can use to create new views on your data, to find information on the used data sources and on the components of the workbook. The design panel consists of three tabs: Analysis, Information and Components.

You can show and hide the design panel by choosing Display for the design panel. You can modify the size and position of the design panel in Microsoft Excel. Your modifications of the design panel will be preserved even if you close Analysis or hide the design panel and show it again.

Working with the design panel, the crosstab is updated after each navigation step. You can choose Pause Refresh to deactivate the permanent refresh.