Visualization N, Data Validation, Pivot Table and Chart
An Excel tutorial by Peter Kalmstrom
In
this demo in the Excel 2016 from Scratch series, Peter Kalmstrom
creates a pivot table view and a chart that show revenues
for the four seasons.
For this to work, only the names of the seasons must be
entered in the Season column. They have to be spelled correctly,
and no alternative expressions must be used.
Therefore Peter takes advantage of the Excel data validation
tool. It creates a dropdown with the approved values, so
that users can select them. No other values can be entered.
In
this demo in the Excel 2016 from Scratch series, Peter Kalmstrom
creates a pivot table view and a chart that show revenues
for the four seasons.
