The content is just an excerpt from the complete note for JSS3 Second Term Internet and Communication Technology (ICT) Lesson Note – Formatting Graphs. Check below to download the complete DOCUMENT

WEEK 8

TOPIC:          – FORMATTING GRAPHS

CONTENT:   – Changing Chart Type

SUB-TOPIC 1

CHANGING CHART TYPE

After creating a chart, you can change it to the type you want. The type you choose depends on how you want to present your data.

  1. Select the chart
  2. Within the chart, click the right mouse button OR
  3. Click on insert on menu bar
  4. Click on change Chart type
  5. Under Chart Type, list click to select the desired chart type (e.g, Column, Bar, Line, etc)

Under Chart sub-type list, click to select the chart sub-typed desired. You can view the chart sample by pressing it and hold to view sample button.

  1. Click on OK when satisfied

Changing from histogram to pie chart using the same data

ADDING AND EDITING CHARTS

Once you have created a chart, you can add more chart data series or copy additional chart data series from a worksheet or another chart. Microsoft Excel offers a variety of ways to edit your chart data

You can change a chart data series by:

  1. Adding a chart data series to a chart
  2. Adding or removing more data point to the existing chart data series.
  3. Plotting the data by rows or by columns.

To add or edit a chart data series with chart wizard tool

To gain full access to the note: DOWNLOAD FILE

Copyright warnings! Do not copy.