Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Discussion (Misc queries) |