Learning outcomes
- Explain how to choose and create an appropriate chart.
- Complete the guided practice safely.
- Check that you can explain the main trend without misleading formatting.
Microsoft Excel
Excel Charts
Learn to choose and create an appropriate chart and explain the main trend without misleading formatting in this beginner-friendly Microsoft 365 lesson.
Before you begin
Open Excel and create a blank practice workbook. Use sample information rather than confidential business data.
Step-by-step instructions
- Open Excel and a blank practice workbook and confirm you are using the intended account.
- Turn monthly sample figures into a labelled column or line chart.
- Pause and check permissions, filenames, recipients, dates or settings that affect the task.
- Test the result: explain the main trend without misleading formatting.
- Save the workbook to OneDrive and check that formulas, formatting and labels still display correctly.
Ian's practical tip: Use sample information first. Once the workflow is correct, repeat it with approved work information and the minimum necessary access.
Practical activity
Turn monthly sample figures into a labelled column or line chart. Your expected result is to explain the main trend without misleading formatting.