Charts in Excel

A chart turns numbers into a picture. Pictures help you understand data much faster than rows of numbers. Excel can build a chart from your data in just a few clicks.

📊 Bar Chart — Fruit Sold
Apple
Mango
Banana

How to Insert a Chart

  1. Select the data, including the headings
  2. Click the Insert tab
  3. Click Recommended Charts or pick a chart type directly
  4. Choose a chart style and click OK

Types of Charts

Chart TypeBest Used For
📊 Bar/Column ChartComparing different items
🥧 Pie ChartShowing parts of a whole
📈 Line ChartShowing change over time
A pie chart showing 3 parts of a total

Parts of a Chart

  • Title – Tells what the chart shows
  • Axis – The lines at the bottom and side showing categories and values
  • Legend – A key explaining what each colour means

🔑 Key Terms

  • Chart – A visual picture of number data
  • Legend – A guide that explains chart colours
  • Axis – A reference line that shows scale or category

✏️ Exercise

  1. Which chart type is best for showing change over time?
  2. Which chart type shows parts of a whole?
  3. What does a legend tell you?

© estudy247.com  |  Junior Computer Skills – Class 5

Leave a Comment

Your email address will not be published. Required fields are marked *