Page 40 - Chinmaya_C6_flipbook
P. 40
CHANGING CHART TYPE
You can change the type of an existing chart at any time. Perform the following steps to change the
chart type:
1 Select the chart and click on Design tab.
2 Click on the Change Chart Type command.
3 Click on desired option
(here we choose Line option).
MARKS OBTAINED
100
90
80
70
60
50
40
30
20
10
4 Click on 0
Hindi English Mathematics Computer Sc.
Line option. 1 2 3 4
Ravi Lakshay
The chart will change to Line Chart as shown above.
SETTING THE DATA RANGE
The chart is created on the basis of data in the cell ranges and when the data is updated within the
range, it gets reflected in the chart immediately. However, when new rows and columns are added,
they are not reflected in the charts. It can be done by following the given steps:
1 Select the chart and click 2 Click on the Select Data
on the Chart Design tab. command in the Data group.
38 Premium Edition-VI Charts in Excel 2016 39

