KEMBAR78
Class - 7 Lesson - 3 Charts in Excel-V | PDF | Chart | Cartesian Coordinate System
Scribd
Upload
2K views3 pages

Class - 7 Lesson - 3 Charts in Excel-V

This document discusses charts in Excel. It provides examples of different chart types including pie charts, line charts, scatter charts, bar charts, and column charts. It then asks several questions about chart formatting and usage, including the differences between bar and column charts, what sparklines are, when line graphs are useful, the differences between embedded charts and chart sheets, and how to format a chart in Excel.

Uploaded by

Rishika Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2K views3 pages

Class - 7 Lesson - 3 Charts in Excel-V

This document discusses charts in Excel. It provides examples of different chart types including pie charts, line charts, scatter charts, bar charts, and column charts. It then asks several questions about chart formatting and usage, including the differences between bar and column charts, what sparklines are, when line graphs are useful, the differences between embedded charts and chart sheets, and how to format a chart in Excel.

Uploaded by

Rishika Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Lesson -3 Charts in Excel

Subject-Computer Science
Class-7
Exercises
E. Match the following:-
1. Pie Charts -Compares data of single series
2. Line Chart -Compares a trend over a period of time.
3. Scatter Chart -Shows relationship between data series
4. Bar Chart - Display data in horizontal columns.
5. Column Chart -Display data in vertical columns.

F. Answer the following questions:-

1. How is the bar chart different from a column chart?


Ans. Both the charts, Bar and the Column charts display
data using rectangular bars where the
length of the bar is proportional to the data value.

Both are used to compare two or more values. However,


their difference lies in their orientation.

A Bar chart is oriented horizontally whereas the Column


chart is oriented vertically.
2. What are Sparklines?
Ans. SPARKLINE is a small graph which is used to represent a
series of data. Apart from a well-fledged chart, it fits into a
single cell. Three different data visualizations available in
Sparkline are:
1. Line
2. Column
3. Win/Loss
It is an instant chart that prepares for a range of values.
Sparkline is used to showcase the data trend for a while.

3. When are line graphs useful?


Ans. A line graph is commonly used to display change
over time as a series of data points connected by straight
line segments on two axes. The line graph therefore helps
to determine the relationship between two sets of values,
with one data set always being dependent on the other set.

4. What is the difference between an embedded chart and a


chart sheet?
Embedded chart: - An embedded chart is considered a
graphic object and is saved as part of the worksheet on
which it is created. Use embedded charts when you want to
display or print one or more charts with your worksheet
data.

Chart sheets: - A chart sheet is a separate sheet within


your workbook that has its own sheet name. Use a chart
sheet when you want to view or edit large or complex
charts separately from the worksheet data or when you
want to preserve screen space as you work on the
worksheet
5. Practical question..

6. Which the two axes in a 2D chart are in Excel? What do


they represent?
Ans. There are two axis in a 2D chart in excel. These two
axes are known as the X axis and the Y axis.
These two axes denote different aspect in different data.
Hence, the parameter of these two axes will differ
depending upon the data that is they are being used for.
X-axis shows categories and Y-axis shows the data range
of values.

7. How do you format a chart in Excel?


Ans. Practical question..

You might also like