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.
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