Cyber Monday

Goal:  Duplicate the chart, including the information for 2011!

 

  1. Copy and paste this chart to a new Excel file so that it is easy to refer to as you are working. 
  2. Using an arrow from your drawing tools, draw an arrow pointing to this chart labeling it as the "Original Chart"
  3. Now create the spreadsheet data that represents the information graphically shown here. 
  4. Use the Internet to look up 2011 Cyber Monday sales estimates and add this to the data. 
  5. Now for the fun part!  Use your spreadsheet data to create a chart that closely mirrors this chart!  Pay particular attention to the many details - you may need to experiment a little to get things to work as you would like...
  6. Using an arrow from your drawing tools, draw an arrow pointing to the chart you created and label is at your "Copycat" attempt.
  7. Arrange and size the charts (and arrows) so that everything fits to one page. 
  8. Add a footer than includes your name, date completed, and class hour.
  9. Rename the tab "Cyber Monday" and color the tab red.  Save!