Page 49 - 2611_SmartGPT Pro V(5.0) C-5

4 Type the
name.

5 Click on the
OK button.

Now, we can use this name in place of the cell address in formulas.

USING CHARTS

A chart is an effective way to display data in pictorial form. It makes it easier to draw
comparisons and analyse the growth, relationships and trends among the values in a
table. Excel provides a variety of different chart formats such as Bar, Column, Pie, Line,
Area, Doughnut, Scatter, Surface and Radar.

COMPONENTS OF A CHART

Chart Title: It describes the main aim and content of the chart.

X-axis: It is the horizontal axis of the chart. It is also called the category axis.
Y-axis: It is the vertical axis of the chart. It is also called the value axis.

Plot Area: It is the rectangular area bounded by the two axes. It contains the actual

chart and includes the plotted data, data series, category and value axis.
Data Series: It is related to the set of values. The bars or slices represent the data values.

Data Labels: These include data values, category name, series name, legend keys and
values from cells.

Gridlines: These can be either horizontal or vertical lines depending on the selected
chart type. It makes it easier to read and understand the values.

Gridlines Chart Title

Plot Area

Data Series
Y-axis
Data Labels
X-axis
Legend

Charts, Formulas & Functions in Excel 47