Charts

Creating a Chart

To create a chart from a worksheet:

  • Select the data on the worksheet to be put into the chart
  • Select the chart type required
  • Enter a title and a “Y” axis label for the chart
  • Label the “X” axis to reflect the data shown

Using the following data:

Img-7WEB

Select the Data

Select the data, including the text which relates to the data.

Img-8WEB

Choose the Insert menu from across the top of the screen.

Img-9WEB

Then, select the type of chart required from the choices available.

Img-10WEB

The chart can be moved around the worksheet by grabbing it with the mouse and moving it.

In the image below, a 2D column chart has been used.

Img-11WEB

2019-03-08T11:01:23+00:00