How to create the PivotChart in Excel At this point, you have a PivotTable that counts the number of invoices per month and by the year. From here, creating the year-over-year PivotChart is easy: ...

If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.

In this article, I’ll show you how to include AND and OR operations in Excel’s FILTER () function. In several spots, you’ll read “AND and OR,” which is grammatically awkward.

Now you have a clear view of how each salesperson did in a specific month, with all variables included. You can right-click on a chart to change the fill and outline color to give it a unique look.

If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter customization tools to limit the number of rows included in your filter results.

How to Make a Cumulative Chart in Excel. By adding all of the data in each of your Excel columns and then creating a chart from the totals of each column, you can generate a cumulative chart in ...