Sunday, February 5, 2012

yogi_Present Statistical Data In Column Chart And Bar Chart


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user hihi said:
how can i make a pivot table? I have to make a graph with how many male, female, and both sexes had different types of leukemia in 1997 and 1999.
The data is shown in:
https://docs.google.com/viewer?a=v&pid=forums&srcid=MDIyMTM4Mzk3OTYzNDIwOTIzNTEBMDYyMTc3NTk2NDAxODE1MzEzNzcBMTM4ODk0NDcuMjU1MS4xMzI4NDc4OTQ3MDAxLkphdmFNYWlsLmdlby1kaXNjdXNzaW9uLWZvcnVtc0B2YnljMjIBNAFnb29nbGVwcm9kdWN0Zm9ydW1zLmNvbQ
-----------------------------------------
following is a solutionto the problem ...
the data is chartable as presented -- I have created a Column Chart associated with tabular data in Sheet1, and a Bar Chart associated with tabular data in Sheet2