The University of Waikato - Te Whare Wānanga o Waikato
Student Learning
Waikato Home Waikato Home > Student Life > Student Learning  > Help with technology
Staff + Student Login

Student Learning: Technology

Spreadsheets 6 - Excel

Here is a video by NDigilabs Nabeel from Youtube.

Video source: VideoExcel - How to create graphs or charts in Excel 2010 (Charts 101)

This video includes:
  1. Choosing the cell that will host the chart
  2. Selecting the type of chart you want from the insert tab on the ribbon
  3. Selecting the data for the chart
  1. Naming the values for x axis and the y axis
  1. Changing the theme (appearance) of the chart
  2. Editing the chart title and legends
  3. Gridlines (under the layout tab on the ribbon)
  4. Data labels (under the layout tab on the ribbon)
  5. Adding trendlines (under the layout tab on the ribbon)