HOW TO USE PIVOT CHARTS IN EXCEL 2013 UPDATE
HOW TO USE PIVOT CHARTS IN EXCEL 2013 DOWNLOAD

HOW TO USE PIVOT CHARTS IN EXCEL 2013 DOWNLOAD

Please click here to download slicer examples demo workbook. This post is very long and has many examples. See it below or head to my YouTube channel. If are just getting started with this AWESOME feature, you must watch the video, NOW. Here is a quick 5 minute video tutorial on Slicers.

With slicers, it is a matter of simple click. With a report filter (or any other filter), you will have to click several times to pick one store.

Add a slicer on region and click on the region you want.

Add region as report filter and filter for the region you want.

There are 2 options for you do drill down to an individual region level. And you want to see how the sales are for a particular region. Slicers are visual filters. Using a slicer, you can filter your data (or pivot table, pivot chart) by clicking on the type of data you want.įor example, let’s say you are looking at sales by customer profession in a pivot report. And here is a quick demo to show why they are my favorite.

If you open the file in Excel 2007, you will see placeholders instead of the Slicers.Slicers are one of my favorite feature in Excel. The zipped file is in xlsm format, and contains macros. On the Sample Files page, go to the Pivot Tables section, and download the file from PT0009 – Survey Pivot Charts. To see the survey data, and experiment with the charts, you can download the sample file from my Contextures website. Then, select a department and/or years of service, to apply that filter to both charts. If you’re using Excel 2010, or later version, you can add Slicers to the pivot tables, and show them on the chart sheet. To see the code, right-click the Surve圜harts sheet tab, and click View Code. If you don’t want to use macros, you could select a question, then click the Refresh All command on the Ribbon’s Data tab.

HOW TO USE PIVOT CHARTS IN EXCEL 2013 UPDATE

IN cell E4, an INDEX formula shows the text for the selected question.Īfter you select a question from the drop down list, event code is triggered, and refreshes the pivot tables, to update the charts. The list is built with Data Validation, based on the list of questions, which is in a range named QuIDList. In cell E4, named SelQNum, an MATCH formula calculates the selected question’s position in the list.Īt the top of the Surve圜harts sheet, there is a drop down list in cell D2. There is a list of questions, with a code and text description for each. Both have Response in the Rows area, and Count of Response in the Values area. Pivot1 has the Dept field in the Columns area, and Pivot2 has Service in the Columns area. There are two charts, and each is based on a separate pivot table. In the Response column, an INDEX formula returns the response for the selected question: The green columns are used in the pivot tables and charts. Each row contains one employee’s responses to the 5 survey questions, as well as their department and years of service. On the SurveyData sheet, there is a named table with the survey results. On the main sheet, there are two pivot charts, showing survey responses by department, and by years of service.Īt the top of the sheet, you can select a question from the dropdown list, and view the survey results for that question. I’ve updated one of the pivot chart sample files on my Contextures website.

How to use pivot charts in excel 2013