Charts / graphs and formulas in Microsoft Excel
This page contains support links for Office 365, Excel 2019, Excel 2016, and Excel 2013.
If you are not sure which version you are using, click here.
Charts / graphs
Formulas
These helpsheets describe ways to calculate using Excel data.
Below are helpsheets for Excel 2003, Excel 2007, and Excel 2010.
If you have difficulty loading the helpsheets, you may need to install the latest version of the 
Adobe Acrobat Reader.
Charts / graphs |
|||
| Create pie graphs, line graphs, column graphs and other data visualisations. | |||
| 2003 | 2007 | 2010 | |
|---|---|---|---|
| Creating a chart / graph | PDF (289kb) | PDF (602kb) | PDF (689kb) |
| Modifying a chart | PDF (209kb) | PDF (385kb) | PDF (510kb) |
| Modifying a pie chart | PDF (107kb) | PDF (176kb) | PDF (172kb) |
| Adding a trend line | PDF (153kb) | PDF (247kb) | PDF (333kb) |
| 2 Y axes in one chart | PDF (152kb) | PDF (389kb) | PDF (634kb) |
Formulas |
|||
| These helpsheets describe ways to calculate using Excel data. | |||
| 2003 | 2007 | 2010 | |
| Simple calculations | PDF (125kb) | PDF (200kb) | PDF (252kb) |
| Autofill | PDF (70kb) | PDF (88kb) | PDF (105kb) |
| Displaying a formula in cells | PDF (210kb) | PDF (206kb) | PDF (176kb) |
| Formula auditing | PDF (110kb) | PDF (165kb) | PDF (284kb) |
| Absolute cell addressing | PDF (99kb) | PDF (123kb) | PDF (199kb) |
| 3D referencing in calculation | PDF (97kb) | ||
| IF statements | PDF (370kb) | ||
| Linking cells, worksheets, and workbooks | PDF (282kb) | ||
| Using Goal Seek | PDF (194kb) | ||
| Using data tables | PDF (161kb) | ||