How to Create an Interactive Excel Pivot Chart

Excel Pivot Table Reports and Excel Pivot Table Charts work “hand-in-hand” to give you the ability to create interactive displays of the information inside your data. You have two options for creating a Pivot Chart in Excel: 1) Add a Pivot Chart to an Existing Pivot Table Report 2) Create a Pivot Chart while you are creating a Pivot Table Report Starting with Excel 2007, the default setting for a Pivot Table Chart is to “embed” the chart on the same worksheet as the Pivot Table Report. You can quickly move this chart to its own Excel worksheet if you choose. Also, beginning in Excel 2007, you get a new PivotTable Tools Chart Filter dialog box – and I like this a lot! With this new PivotChart Filter Dialog Box, you can interactively choose the fields and filter the fileds that you wnat to chart. Bot the Chart and the underlying Pivot Table Report are changed dymanically. I invite you to visit my online shopping website – shop.thecompanyrocks.com – to view all of my videos and to explore the many resources that I offer you. Danny Rocks The Company Rocks
Video Rating: 4 / 5

Get the book now