Page 31 - iPro_trackGPT_V5_Class8
P. 31
Gridlines
Chart Title
Chart Area
Plot Area
Y-axis Title
Data Series
Y-axis
Data Labels
X-axis
X-axis Title
Legend
Data Series: A data series is a collection of related values.
Data Labels: Data labels show data values, category names, series names, legend keys, and
values from cells.
Gridlines: Gridlines can be horizontal or vertical, depending on the chart type. They help
make it easier to read and understand the values.
Legend: The legend is a key that explains the symbols and colors used in the chart.
Chart Area: This is the area that includes all the objects and elements in a chart.
X-axis Title: The X-axis title describes the information or categories represented on the
horizontal axis of the chart.
Y-axis Title: The Y-axis title describes the measurement or values represented on the vertical
axis of the chart.
Types of Charts in Excel
Excel gives you different types of charts to fulfill your requirement. Depending on your data,
you can choose the most suitable one. Some commonly LINE CHART
used chart types available in Excel include Column Chart,
Line Chart, Pie Chart, Bar Chart, Area Chart, Scatter Chart,
Surface Chart, and Radar Chart.
Line Chart: It is used to show trends over a period of time.
It connects data points with lines, helping to visualise
trends and patterns. This makes it easier to understand
how values increase or decrease over time.
COLUMN CHART Column Chart: A column chart is a type of graph that
uses vertical bars to show and compare different amounts
of data. Each bar represents a category or time period,
and the height of the bar shows the value or amount for
that category.
Spreadsheet—Functions and Charts 29

