Drawing graphs (charts)
Level of difficulty: Intermediate
Create your own chart - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps:
| Tip sheets | Glossary | Home | Contents |
Drawing graphs (charts) |
Level of difficulty: Intermediate |
|
| As a principal there will be times when you have information (especially numerical data) in a table that you would prefer to see in a graph (chart), such as student attendance figures, budget information or any similar information. This can easily be achieved by using Microsoft Excel. | |
|
|
|
|
Create your own chart - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps: |
||
Description |
Resources |
|
| 1 | Start Microsoft Excel | How to start Microsoft Excel |
| 2 | Open existing file: Find the file of data you have saved and open it. If you do not already have data in a table then create one now. | How to open an existing file |
| 3 | Select data: Before creating the chart you will select only the data in the table that you require to be in the chart. | How to select data |
| 4 | Create a chart: The chart wizard window will open and you will be guided through the process. | How to create a chart |
| 5 | Select a chart type: Choose the most appropriate type of chart that suits your data. You will notice that there are options for different types of charts such as pie charts, bar and line graphs. | How to select a chart |
| 6 | Change appearance of chart: You can now change some of the details (Title, legend etc.) that appear on your chart. | How to format your chart |
| 7 | Save the workbook: Save the workbook before printing | How to save |
| 8 | Print preview: Preview is quite essential in a spreadsheet because you will probably not be sure where your page boundaries are before printing | How to print preview |
| 9 | Print the chart | How to print |
| Related scenarios Write a report in Microsoft Word Develop a budget in Micorosft Excel Insert a chart from Microsoft Excel in your report |
|||
 |
|||
