For example, you want to compare the sales volume of all fruits in a given month in a Pivot Chart, how could you filter the sales volume by this month? Here I will show you two ways to filter by month in a Pivot Chart in Excel easily.
Quickly filter dates by day/week/month/quarter/year only in Excel
Kutools for Excel provides a powerful Super Filter utility to help Excel users quickly sort dates by day/week/month/quarter/year only, filter text strings by text length, filter text strings by Uppercase or lowercase, etc. Full Feature Free Trial 30-day!
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Filter by month in a Pivot Chart if axis labels/legends are dates
Let's say you have created a Pivot Chart and the axis labels are dates as below screen shot shown, you can easily filter the Pivot Chart by month as follows:
Step 1: Click the Date filed button in the Pivot Chart, and then select the Date Filters > All Dates In the Period and then select a month, such as January.
Note: In Excel 2007, the filed buttons are not displaying in Pivot Chart, but there is a PivotChart Filter Pane for filtering. Click the Pivot Chart, go to the PivotChart Filter Pane's Axis Fields (Categories) section (or Legend Fields (Series) section), click the arrow besides the Date, and then click Date Filters > All Dates in the Period > January or other month.
Now only data points occurred in selected month are filtered out. See below screen shot:
Filter by month in a Pivot Chart if axis labels/legends are not dates
In some cases, you may create a Pivot Chart and the axis labels or legends are not dates as below screen shot shown. Now if you have to filter the Pivot Chart by month, you can do as follows:
Step 1: In the Pivot Chart Fields pane, drag the Date filed from Choose fields to add to report section to the Axis (Categories) section or Legend (Series) section.
Note: You can also right click the Date filed in the Choose fields to add to report section, and select Add to Axis Fields (Categories) or Add to Legend Fields (Series) from right-clicking menu.
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel
2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features
30-day free trial. 60-day money back guarantee.