Friday, May 13, 2005

The power of pivot charts'n'tables...

... but what is a pivot chart or a pivot table? Why would we even want to use one?

See if you can find out, then add a comment back here with a link to the page you found (don't worry Lynne, we'll not spend more than 5-8 mins searching :-)). After finding out a bit about them, we're going to download an example file from MS and create a few Pivot Charts to see why they might be useful.

5 Comments:

Anonymous Anonymous said...

There is a site with heaps of info here
http://peltiertech.com/Excel/Pivots/pivotlinks.htm

9:36 AM

 
Blogger Michael said...

In reply to kadaeux... In your first assign, you've got a bunch of ships of different classes. If I asked you to display a bar-chart that showed how many of each type of ship you had in the yard, could you do it? give it a try!

9:45 AM

 
Anonymous Anonymous said...

A pivot chart is a easier way of viewing data on the spread sheet across different colums in excel which gets displayed in a pivot table which is just the representation of the data

9:45 AM

 
Anonymous Anonymous said...

A pivot table creates an interactive summary from many records.
A pivot chart is an interactive graphical representation of the data in a Pivot Table.
http://peltiertech.com/Excel/Pivots/pivotstart.htm

9:46 AM

 
Anonymous Anonymous said...

This has got a bit of info.. pretty good..


http://www.ozgrid.com/Excel/excel-pivot-tables.htm

2:00 PM

 

Post a Comment

<< Home