Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the Excel Chart Month on Month Comparison.

You can show the values as the Difference From previous months, years, days, etc. Â This is just great when your boss asks you how you are tracking to the previous months, years, days…

## Watch our free training video on how to Show the Difference From Previous Month with Directional Icons

Follow theÂ step-by-step tutorial on How to Show Excel Month on Month Comparison and download this Excel workbook to practice along:

STEP 1:Select any cell in the data table.

STEP 3: Insert a new Pivot In the Create PivotTable dialog box, select the table range and New Worksheet, and then click OK.

STEP 4:Â In theÂ ROWSÂ section put in theÂ SalesÂ MonthÂ field, in theÂ COLUMNSÂ put in the FinancialÂ YearÂ field and in theÂ VALUESÂ area you need to put in theÂ SalesÂ field twice, I explain why below:

The Pivot Table will look like this:

STEP 5: Now click on the second Sales field’s (Sum of SALES2) drop down and choose Value Field Settings

STEP 6: Now you need to select the Show Values As tab and from the drop-down choose the Difference From

STEP 7:You need to select the Base Item as (previous) and Base Field as Sales Month and press OK. Â So it will read the “Difference from the previous Sales Month

STEP 8: You can do some cosmetic changes by going back into the Values Field Settings (from step 3) and changing the Custom Name to show whatever you like eg. Diff. From Previous Month or Monthly Variance.

From in here, you can also click on the Number Format (bottom left-hand corner) to change the way the numbers show:

STEP 9: To create a chart with this data, Go to PivotTable Analyze > PivotChart.

STEP 10: In the Insert Chart dialog box, select Column and click OK.

The month to month comparison excel chart will appear in the worksheet.

STEP 11: Click on the filter button in the chart and select 2012.

This completes our tutorial on month over month comparison Excel!

Further Learning:

Make sure to download our FREE PDF on theÂ 333 Excel keyboard Shortcuts here: