Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Knows too little
 
Posts: n/a
Default Explain Pivot tables & charts

What is the difference between a table and a pivot
table? Between a chart and a pivot chart. Why would one
prefer one type versus another?
  #2   Report Post  
Ken Wright
 
Posts: n/a
Default

Take a look here for a guide to pivot tables and you should see the
benefits:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Knows too little" wrote in message
...
What is the difference between a table and a pivot
table? Between a chart and a pivot chart. Why would one
prefer one type versus another?



  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Ken, thanks for the plug.

In short, Pivot Tables are a hugely powerful, dynamic, interactive tool for
analyzing data in any number of different ways. It's well worth the hour it may take
to figure them out.

Pivot charts capture some of this power in chart form, while at the same time
removing a lot of the functionality of regular charts. I sometimes use pivot charts,
but I'm more likely to make a regular chart, then remake it when the data changes
because it can't keep up with the size and shape of the pivot table the way a pivot
chart can. But the pivot chart loses all its formatting when the pivot table
changes, so that's not really much of a disadvantage.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Ken Wright wrote:

Take a look here for a guide to pivot tables and you should see the
benefits:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables Barb R. Excel Discussion (Misc queries) 0 March 9th 05 03:35 PM
Can links between Excel 2003 Pivot Charts and their pivot table b. Mark Allen Charts and Charting in Excel 2 March 5th 05 06:24 PM
Product Function in Pivot Tables from Multiple Consolidation Range bbishop222 Excel Worksheet Functions 0 February 22nd 05 05:55 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 02:34 AM
Pivot Tables Big Red Excel Discussion (Misc queries) 3 January 26th 05 09:38 PM


All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"