Now that you know how to create a Basic Chart in Excel, we will now explore how you can create an Excel Pivot Chart using the same data form our prior tutorial.
In our prior tutorial you needed to manually sum up the Hours per Month in order to get the data into a format that would display nicely on a chart. Making a Pivot table of the data instead, can help you produce your chart more quickly, as well as allowing you to change it more easily in the future.
Making an Excel Pivot Chart
- Insert a Pivot Table into cell I1 of the above file. If you need a review of how to create a pivot table, please see our Pivot Table tutorial.
- Select Cells A1 through G10 and click OK
- Add Month to the Row Labels section
- Add Hours per Month to the Values section as a Sum
- Click on your Pivot
- Go to your PivotTable Tools – Options tab
- Click on PivotChart
- Choose 2d and click OK.
You now have a Chart just like the one from the last tutorial except now you can control the chart with a pivot table. Filtering out March from the Pivot will make it filter out from the chart as well.
Note that Pivots sort ascending by default. You may want to change the order of the Months from Feb-Jan-Mar to Jan-Feb-Mar to get your chart in a chronological order.
Please see the below for all steps in making the Pivot Chart and Ordering the Fields.
If you liked this content and found it helpful, please like the page and leave a comment below. You can also ask questions on the Forum to get personalized help on your issues and questions.