Page 22 - 2403_Trackpad_V5.1_C6_Fb
P. 22
DOUGHNUT CHART
Doughnut Chart
A doughnut chart consists of more than one CHANGING CHART TYPE
data series. Each ring represents one data You can change the type of an existing chart at any time. Perform the following steps to change the
series in this chart. It displays the relationship of chart type:
parts to a whole.
1 Select the chart and click on Chart Design tab.
Which chart is used to display the data in the form of long rectangular
uiz Bee rods? 2 Click on the Change Chart Type command.
_______________________________________________________________
3 Click on desired option (here we choose Line option).
Line chart
CREATING A CHART
The first step in creating a chart is collecting the data which will be displayed in the chart. To create
a chart, follow the given steps:
2 Click on the Insert tab. 4 Click on Line with
Markers option.
5 Click on the OK button.
3 Choose the
desired chart from The chart will change to Line Chart as shown above.
1 Select the data the Charts group.
range.
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
The chart will appear on the worksheet. 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:
CHART TITLE
100
1 Select the chart and click 2 Click on the Select Data
80
on the Chart Design tab. command in the Data group.
60
40
20
0
Hindi English Mathematics Computer Sc.
1 2 3 4
Ravi Lakshay
20 Premium Edition-VI Charts in Excel 2021 21

