Thursday, October 25, 2012

yogi_Show Month-Year Rather Than Date In Chart And Pivot Table in Sheet2 From Table In Columns A to D In Sheet1

                                           Google Spreadsheet   Post  #826
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Oct 25, 2012
user jigarashah said: (!category-topic/docs/spreadsheets/aS_QTsQbb3s)
show month instead on date in chart
I have a detail sheet with date and values. 

I want to create summary report (monthly) so i first got month out of date with =datevalue(TEXT(A2, "mmmm-yy")) 

Then created pivot table. which summarized data. Now created chart out of it. In chart i want to show month not date. (also if possible, in pivot table)

Look at sample here

following is a solution to the problem