Embedded Files
CHARTS
Formula Use & Explanation: Charts are used to visually and effectively depict data.
Example Used: Make a simple chart from the data below to showing the salary scale.
Formula: Select all the data below and press the F11 key.
1
2
3
4
5
6
7
8
A
Name
Abc
Def
Ghi
Jkl
B
Salary
15,000
25,000
35,000
45,000
C
D
E
F
G
CHARTS STEPS IN DETAIL
STEP 1
Select all the data as shown above highlighted in yellow, i.e. from cell A1 to cell B5.
Now press the F11 key
STEP 2
Right click on the Chart to view the different Options to edit the Chart.
STEP 3
The Format Plot Area option, lets you change the chart background colours.
STEP 4
The Chart Type option, lets you change the chart to a Bar or Line chart, etc.
STEP 5
The Source Data option, lets you choose data from a different Sheet.
STEP 6
The Chart Options option, lets you name the chart and make changes to the way the data is displayed in the chart.
STEP 7
The Location option, lets you change the location of the chart i.e. either in the same Sheet or as a Sheet by itself.
Page updated
Google Sites
Report abuse