![excel pivot chart date axis continuous excel pivot chart date axis continuous](https://peltiertech.com/wp-content/img200806/PCht_bydate_grp2.png)
![excel pivot chart date axis continuous excel pivot chart date axis continuous](https://www.w3schools.com/EXCEL/img_excel_chart_line_4.png)
![excel pivot chart date axis continuous excel pivot chart date axis continuous](https://i.stack.imgur.com/v1D7w.png)
all the dates listed individually (as shown in the video).Group Dates by Year and MonthĪfter you add the Work Date field, depending on your Excel version, and your option settings, you might see There are detailed instructions for these fixes on the Pivot Table Compare Years page of my Contextures site, and short notes below. Move Year to Columns area (pivot table) / Legend area (pivot chart).There are 2 key things to fix in the pivot chart, if you want to compare the work order counts per month, year over year: Work Date – Rows area (pivot table) / Axis fields (pivot chart).In this example, there is a named Excel table with 2 years of data from service call work orders.Ī pivot table and pivot chart were created from that data, with 2 fields added to the layout:
EXCEL PIVOT CHART DATE AXIS CONTINUOUS HOW TO
This video shows how to create a pivot table, and make a pivot chart that lets you compare two years of data. This short video shows how to compare annual data in Excel pivot chart. If you have a couple of years of daily data in Excel, you can use a pivot chart to quickly compare that data, month by month, year over year.