Under the ACTIVE tab, the tables from which the fields are added to PivotChart are displayed. Under the ALL tab, all the data tables in the Power Pivot Data Model are displayed.
PivotChart Fields ListĪs in the case of Power PivotTable, Power PivotChart Fields list also contains two tabs – ACTIVE and ALL. You need to decide what is required to be displayed. Note − The display of field buttons and/or legend depends on the context of the PivotChart. The value field buttons on the chart are removed. Select Hide Value Field Buttons on Chart from the dropdown list. The Legend is removed from the PivotChart. Uncheck the box Legend in the Chart Elements list. The Chart Elements dropdown list appears. You can remove the legend and the value field buttons for a tidier look of the PivotChart.Ĭlick on the button at the top right corner of the PivotChart. The Value Field Buttons appear on the PivotChart. The Values appear in the Legend in the PivotChart, with title Values. In the PivotChart, column chart is displayed by default. The use of field buttons is to filter data that is displayed on the PivotChart.ĭrag TotalSalesAmount from each of the four tables– East_Sales, North_Sales, South_Sales and West_Sales to ∑ VALUES area. Two field buttons for the two selected fields appear on the PivotChart. Select New Worksheet and click OK.Īn empty PivotChart is created on a new worksheet in the Excel window.Īs you can observe, all the tables in the data model are displayed in the PivotChart Fields list.Ĭlick on the Salesperson table in the PivotChart Fields list.ĭrag the fields − Salesperson and Region to AXIS area. The Create PivotChart dialog box appears. Select PivotChart from the dropdown list. Suppose you want to create a PivotChart based on the following Data Model.Ĭlick the Home tab on the Ribbon in Power Pivot window. Henceforth we refer to them as PivotCharts, for simplicity.
In this chapter, you will learn about Power PivotCharts. Though it has some features similar to Excel PivotChart, there are other features that make it more powerful. A PivotChart based on Data Model and created from the Power Pivot window is a Power PivotChart.
0 kommentar(er)
