Before You Begin
A
PivotChart is based on a PivotTable: they go together. This lesson
begins with a PivotTable. After the PivotTable is set up, we will
review the PivotChart options in Microsoft Excel 2010.
You can use a spreadsheet that you
created or download a sample spreadsheet if you wish.
1. Try This: Open a Sample Spreadsheet
Open a sample spreadsheet: Sales2010.xlsx
Go to the Original Data sheet.
What Do You See? This sheet shows the product sales for
Charlotte' Website. The first row is BOLD: it is the Header Row.
There are many rows of data.
Memo to Self: You do not have to MATCH the numbers shown on
these pages. It is more important that you begin with some data and
understand the options.
