University of Bath

Excel: Creating charts

Learn how to summarise trends, reflect proportions and anomalies in Excel using the Charts function.

10 May 201810.00am
10 May 201812.00pm

About the workshop

This course is for experienced Excel users who wish to learn the most important features of Charts. The course will help you to gain an understanding of how charts are created and presented in Excel. Charts are used to summarise data, reflecting proportions, trends, and anomalies in your data Representing your data graphically in a chart helps people to interpret the data. The course assumes you already have an excellent working knowledge of Excel.

Learning outcomes

After completing this course, you will be able to:

  • create charts in Microsoft Excel
  • change the chart type
  • change the location of a chart
  • format chart elements
  • add trend lines and error bars to charts
  • save a chart template