J Jan Karel Pieterse Mar 18, 2004 #2 Hi Andrius, What's this PivotTable and PivotChart? Click to expand... They are tools to summarise data, e.g. to show the total amount of Apples sold per region and per year, using a database like table in your spreadsheet. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com
Hi Andrius, What's this PivotTable and PivotChart? Click to expand... They are tools to summarise data, e.g. to show the total amount of Apples sold per region and per year, using a database like table in your spreadsheet. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com
F Frank Kabel Mar 18, 2004 #3 Hi see the following links for an introduction: http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html
Hi see the following links for an introduction: http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html
M Max Mar 18, 2004 #4 And .. another good pivot table intro, well illustrated for beginners to intermediates ... especially for those using xl97 <g> Pivot Table Tutorial By Ed Ferrero at his site: http://edferrero.m6.net/Pivot.html
And .. another good pivot table intro, well illustrated for beginners to intermediates ... especially for those using xl97 <g> Pivot Table Tutorial By Ed Ferrero at his site: http://edferrero.m6.net/Pivot.html