Visualization O, Pivot Table and Chart, Percentage
An Excel tutorial by Peter Kalmstrom
In
this demo in the Excel 2016 from Scratch series, Peter Kalmstrom
creates a pivot table and a chart that show orders and customers
for the twelve months of the year.
Peter creates two pivot table views, which reflect in the
chart. One of them shows the order trend over time, and
the other one shows the orders for each customer in percent
of the total.
At the end of the demo Peter shows how to answer questions
about orders of different months by sorting and filtering
the columns in the Excel table and by adding a Total row
to the table.
In
this demo in the Excel 2016 from Scratch series, Peter Kalmstrom
creates a pivot table and a chart that show orders and customers
for the twelve months of the year.
