Creating a Chart in Pivot Table

In dbForge Fusion for SQL Server, you can view pivot data as a chart. Such an option helps to visualize data dependencies and compare it.

You can view a chart associated with the needed pivot data directly in the pivot table document, in a special view.

Let’s build a chart based on the data of the pivot table created in the Creating a Pivot Table topic.

  1. Open the Charts view of the pivot table document by clicking the Show Chart button on the pivot table document toolbar.

  2. Select the data that should be displayed on the chart on the Pivot Table view of the document by pressing CTRL and clicking the needed cells of the pivot table or by selecting the cells of the table with the left mouse button pressed:

  3. Adjust the chart options using the Chart view toolbar, shortcut menu, or Chart Designer.