create pivot chart using pivottable on excel for mac

Create Pivot Chart Using Pivottable On Excel Download The Data

So, now that youve laid the foundation, lets break down some other tools and features you can use to make the most of the pivot tables you create.

Instead of needing to change the year filter on both of those pivot tables, he could create a slicer for the year.

Select the variable you want to sort your data by (in this case, its the year) and click OK.

I recommend positioning it on top of your pivot tables, so that you can look at everything in one glance.

To do so, right click on the slicer, select Report Connections, and then choose the pivot tables that should be connected to that slicer.

While getting the slicer established involves a little bit of work, it can save you tons of elbow grease down the roadparticularly if youre using a lot of different pivot tables.

Doing the profit calculation himself outside of the pivot table is rather cumbersome, because he needs to subtract the Q1 cost from the Q1 sales, do the same for Q2, and so on and so forth.

To figure out profit, he knows he needs to subtract his cost from his sales.

So, he would click on sales and hit Insert Field, type in the minus sign, and then click on Cost and hit Insert Field.

He wants to dig in deeper and see his beer sales for each quarter for each type of beer (Amber, Pilsner, IPA, or Stout).

Fortunately, he can do that with just a few clicks using his original pivot table as his starting point.

Click within your pivot table, head to the Pivot Table Analyze tab within the ribbon, click Field List, and then drag Type to the filters list.

After Jason highlights Type as what he wants to break the data down by, Excel will create a new worksheet with a pivot table for each type of beer.

If he wants to remove the subtotals, he can easily do so following those same steps and selecting the Dont Show Subtotals option.

He just needs to double-click on that number in the cell, and Excel will open up detailed information in a new worksheet.

Jason accidentally spelled growler as grolwer, for example, and now it appears that way everywhere.

That will make that same correction across the entire workbook.

Put them to work, and youll make summarizing and analyzing your data a total breeze.

When she escapes her computer, she enjoys reading, hiking, golfing, and dishing out tips for prospective freelancers on her website.

Create Pivot Chart Using Pivottable On Excel Download The Data

Computergaga). Download the data sheet and try the challenge today.

Create Pivot Chart Using Pivottable On Excel For Mac