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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |