GO STEP BY STEP ON CREATING CHARTS AND GRAPHICS IN MS EXCEL


 

1. Why Use Charts and Graphics?

Charts make data visual and easy to understand. Instead of just numbers, you can quickly spot patterns, comparisons, and trends.


2. Creating a Chart

Step 1: Select Your Data

  • Highlight the data you want to visualize (e.g., Names and Scores).

Step 2: Insert Chart

  • Go to the Insert tab on the Ribbon.
  • In the Charts group, choose the type of chart you want (Column, Bar, Pie, Line, etc.).

Step 3: Customize Chart

  • Chart Title: Rename it to describe your data.
  • Axes Titles: Label the X-axis (categories) and Y-axis (values).
  • Legend: Shows what the colors/symbols mean.
  • Styles & Colors: Use the Chart Design tab to adjust style and layout.

3. Common Types of Charts

  • Column/Bar Chart → Compare values across categories (e.g., student scores).
  • Pie Chart → Show percentages of a whole (e.g., market share).
  • Line Chart → Show trends over time (e.g., monthly sales).
  • Area Chart → Like a line chart, but filled with color.
  • Scatter Chart → Show relationships between two sets of numbers.

4. Adding Graphics

Excel also allows you to add visual elements to improve presentation:

  • Shapes: Go to Insert → Shapes (arrows, boxes, circles).
  • Pictures: Insert images from your computer.
  • Icons & SmartArt: Use built-in graphics for flowcharts, processes, or diagrams.
  • Sparklines: Tiny charts inside cells (Insert → Sparklines).

5. Example Activity

Imagine this table:

Name

Score

John

75

Mary

40

Peter

90

Lucy

55

James

30

👉 Create a Column Chart to compare student scores.
👉 Create a Pie Chart to show each student’s percentage contribution to the total score.

👉 Inside Excel, you can insert these charts directly by:

1.     Selecting the Name and Score columns.

2.     Going to Insert → Charts.

3.     Choosing Column Chart or Pie Chart.

Post a Comment

Previous Post Next Post