Week 2-1 Excel

How good are you at creating graphs? If the data table is formatted well, then the automatic graph-building functions in Excel will make your job much easier! Let’s practice:

1. Create a Line graph using one of the performance metrics.
2. Column (or bar) graph using the same data from #1.
3. Create a Radar chart using all the metrics during the most recent period.
4. Create a Scatter (X,Y) plot — with data in columns side-by-side
5. Create a Scatter (X,Y) graphs — with data in columns that are NOT side-by-side