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     www.energyefficientbuild.com.    Oct 25, 2012
user jigarashah said: (http://productforums.google.com/forum/?zx=r3nme9qg99cb#!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

https://docs.google.com/a/jigarshah.net/spreadsheet/ccc?key=0AsLfRjSVpTcmdEFraFI2TzI1SXFhNDRNSS14ODh4bmc#gid=0

-----------------------------------------------------------------------
following is a solution to the problem