Video Transcript: Use Field Buttons to Filter Pivot ChartPivot charts have improved in Excel 2010 and I'm going to show you the new filtering feature which is much easier than it was in Excel 2007. Show Insert Pivot ChartTo insert a pivot chart, I'm selecting a cell in the pivot table. And then, on the Ribbon, under Pivot Table Tools, I'll click Options. And in the Tools group, click PivotChart I'm going to select a Column chart type And the first one here, which is the Clustered Column And click OK That inserts a chart right on the active worksheet. I can point to one of the corners of the chart and make it a bit smaller Filter Pivot ChartAnd to filter now, I can use any of the field buttons, that are on the chart. So if I only want to see a specific product or date, then I can click the arrow and filter right in the pivot chart. So perhaps I just want to see April 7th And that filters both the chart and the pivot table. Remove Pivot Chart FiltersTo remove the filters, I can go back, and click All And that shows all the data again. Show or Hide Field ButtonsThere's also a setting on the Ribbon, if you go to PivotChart Tools, and click Analyze. There is a Field Buttons setting, that you can show or hide specific buttons, that are on the chart, or hide all of them. A guide to enhancing your Microsoft Excel skills There are many functions and capabilities that are possible when dealing with data in Microsoft Excel. A very important aspect of Excel that can deal with data in a variety of ways is something called pivot tables. Pivot tables are important because they allow anyone to filter and extract significance about the data… Recommended textbook solutions Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 726 solutions
Service Management: Operations, Strategy, and Information Technology7th EditionJames Fitzsimmons, Mona Fitzsimmons 103 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface5th EditionDavid A. Patterson, John L. Hennessy 220 solutions
Fundamentals of Database Systems7th EditionRamez Elmasri, Shamkant B. Navathe 687 solutions From the course: Excel 2016: Pivot Tables in Depth Video is locked. “ - When you analyze data using a pivot chart, you must close attention to the individual values in your data sets. Evenso, it's often beneficial to take a step back and look at the overall trends in your data. You can enhance your analysis by projecting future values, assuming current trends stay constant, by adding a trendline to your pivot chart. I will show you how to add a trendline to a pivot chart. As my sample file, I'll use the Trendline Excel workbook. You can find that in the Chapter06 folder of your Exercise Files collection. I have my data laid out in a line chart, although I could also use a column chart. And what I'd like to do is project future values, say to the first quarter of 2016, based on the existing values within the pivot table data set. So you can see here that I have data for 2014 and 2015, all four quarters of both years. To add a trendline, I will click the body of the pivot chart and then click the Chart Elements button. And then from among the Chart… Contents From the course: Excel 2013: Pivot Tables Video is locked. “ When you summarize time series data in the PivotChart, you might want to add a trend line to see what your data would look like in
the future if current trends continue. In this movie, I will show you how to add a trend line to your PivotChart, so that you can make that type of forecast. I'll use the Trendline sample file, which you can find in the Chapter06 folder of your Exercise Files archive. This PivotChart summarizes quarterly sales data for a number of departments in the company, but I have filtered the PivotChart, so that it only displays data for one department; in this case, the Sports department, just to simplify
the chart that we will create. To add a Trendline to the PivotChart, first you click the PivotChart, and then click the Chart Elements button. Doing so displays the Chart Elements list, and you can go down to the Trendline item, and check this box to display the Trendline in the body of the PivotChart. This Trendline shows what sales would have looked like, if they… Contents |
