Creating a Chart using Data from Columns and Rows

Selecting Data for a Chart

Understand that a chart is a visual representation of your spreadsheet data.
Know that to create a chart, you first need to select the data you want to include.
Identify that data should be organised in columns or rows on a single sheet and should include a label.
Know to select data by clicking and dragging over the cells you want to include in your chart.

Remember to select the ‘Insert’ tab and choose the ‘Chart’ option.
Understand that you can choose from a variety of chart types, including bar, pie, line, and column charts.
Know that once you have selected your preferred chart type, the chart will appear in your worksheet with the selected data.
Know that you can move and resize the chart by clicking and dragging it.

Learn how to add chart elements such as a title, labels, legend, and gridlines.
Realise that the ‘Chart Tools’ tab will appear when you click on your chart, and you can use it to customise your chart further.
Remember that layouts and styles can be applied to charts to enhance their appearance.
Know how to adjust the axis values and scaling to suit your data.
Understand that you can change the style and colour of your chart from the ‘Chart Styles’ group.
Recognise that you can preview changes before applying them to the final chart.

Learn how to update chart data in real time by modifying the data in your cells.
Acknowledge that if you add new data to your worksheet, the chart will not update automatically – you need to manually adjust the data range.
Realise that you can switch between rows and columns to rearrange chart data through the ‘Select Data Source’ dialog box.

Understand the importance of checking your chart in Print Preview before printing.
Learn how to print a chart either as part of the worksheet or as a separate page using the ‘Print’ settings.
Note that when printing a chart separately, you can specify the print quality, layout, and headings in the ‘Page Setup’ dialog box.