What makes a pivot table a “pivot table” and how is it different from a regular graph or chart?

Question

What makes a pivot table a “pivot table” and how is it different from a regular graph or chart?

In: 1

Answer 1

A pivot table is a way of dynamically presenting data in a spreadsheet program like Microsoft Excel.

For example let’s say you had a spreadsheet of your company’s monthly financial results for the last 20 years. In a pivot table, you could quickly do things like showing each year’s total, or each year’s average, things like that.