Pivot Table query



I have two columns in excel. Column 1 = Month-Year, Column 2 = Total sales of the Month.

I want to creat a pivot chart which shows yearly sales.

For an exaple I have data as mentioned below.

Jan-2010            $100

Feb-2010            $200

Mar-2010            $300 ………..and so on till Mar-2017

I wanted to show sell of 2010, 2011…. in my pivot chart.

When I created a Pivot chart is on monthly basis, but I wanted to display it on yearly basis. Can you please suggest the solution.





By: Rohit Agarwal

Leave a Reply

Your email address will not be published. Required fields are marked *