![how to use pivot charts in excel how to use pivot charts in excel](http://ladyexcel.com/wp-content/uploads/2017/11/Dashboard.png)
Try both or either method to see what your table looks like, and drag fields in and out (and reorder them in the box) until it looks the way you want. If you have some classes that have the same date but different names (or vice-versa), you will want to use Class in addition to Lesson Date to distinguish them. If your classes all have different names, you can simply use Class. If your classes all have different dates, you can simply use Lesson Date for your columns. Drag Video View % from the list box into the Values box.Drag Class and/or Lesson Date from the list box into the Columns box (see note below).Drag Student Name from the list box into the Rows box.Drag and drop fields from the list into the locations below the list as follows:.
![how to use pivot charts in excel how to use pivot charts in excel](https://www.myexcelonline.com/wp-content/uploads/2019/02/Recommended-Pivot-Tables-01-768x341.png)
![how to use pivot charts in excel how to use pivot charts in excel](https://icdn3.digitaltrends.com/image/excel-pivot-tables-from-scratch-selected-2-1070x810.jpg)
Once again, the below procedure uses a CSV export from the Section > Analytics > Students page, but you can apply these steps to any exported data set. OR you can create ONE pivot table, then adjust which data it uses. Each new pivot table lives in a different tab/worksheet of the single XLSX file. You can create as many pivot tables as you want.
![how to use pivot charts in excel how to use pivot charts in excel](https://www.techonthenet.com/excel/pivottbls/images/data_source2016_001.png)
You don't HAVE to do this until you're done creating your pivot table, but doing it first ensures you can just click the Save icon if you get your pivot table(s) configured the way you want.įrom there, follow the below instructions to create a pivot table. Pivot tables generate new worksheets in the file (the original data sheet is unchanged), and CSV file types can only have a single worksheet. Generate a CSV Export from Echo360 and open it in Excel. Once set up, you can add or exchange metric values very easily, to show you other data for each student and each class.įirst things first. The metric we want to see is used as the value, with one row for each student and one column for each class. In our example, we are using Pivot tables to give us at-a-glance listings of student engagement metrics from a course section. You can change these as needed to view different values from the same exported data-set. Pivot tables are essentially "data views" where you identify which data items you want for the rows, and which data items you want for the columns, then select the values you want for each row-column intersection. For more information or other steps, refer to the Excel documentation. The information given here is provided as a GUIDE to this Microsoft Excel feature, and specifically for the Echo360 data made available through the platform. It uses the Student Analytic Data export for a section as an example, to show how you can take the sometimes VERY large data files and create "views" of the data that you find most useful. This article is designed to provide you with guidance on creating Pivot Tables in Excel.