CHAPTER 3
Charts in Excel
A. Tick (ü) the correct answer and fill in the
blank.
1. _F11_ key is used to insert a chart quickly.
2. A _Pie_ chart displays data in the form of a circle.
3. The format task pane appears on the _right_ of the screen.
B. Identify the type of chart.
C. Fill in the blanks using the given words.
1. Y-axis is also known as _Value _ axis.
2. Chart are easier to understand and _analyse_.
3. _Column charts display data in the form of a vertical bars.
4. The two tabs appear on creating a charts are _Format and Design.
5. _Legends_ helps to identify colors, patterns, symbols assigned to data series.
D. Write T for true or F for false.
1. Charts are the useful tools for comparing the data values. True
2. A line chart represents changing trends in data over a period of
time. True
3. Y-axis is also known as category axis. False
4. Column charts can represent only one data series. False
5. In a bar chart, categories are represented on the vertical axis and values represented the horizontal axis. True
E. Answer in short.
Que 1 What are data series?
Ans -. Data Series:- The bars, lines, slices other
elements represent the data value.
Que 2 Which chart component help to
recognise different data series?
Ans -. Legends help to recognise different data series.
Que 3 What is the use of chart
style commands?
Ans – The Chart Style command is used to change the visual look of the
chart.
Que 4 What are legends?
Ans - Legend:- This helps to
identify colors, patterns, symbols assigned to data series.
Que 5 Write the shortcut key to
insert the chart in Excel spreadsheet.
Ans - F11
F. Answer in detail.
Que 1 What do you understand by chart? Explain the
benefits of using chart.
Ans – A pictorial representation of numeric data is called a chart.
There are many advantages of charts.
* Charts present
data and information in an attractive manner.
* Charts are
easier to understand and analyse.
* Charts have a
more impressive and informative than a simple spreadsheet.
Que 2 What is difference between Bar and Column chart?
Ans – Column chart: A column chart displays
data in the form of vertical bars. It is used to compare values over a period
of time. In a column chart, categories are organised along the horizontal axis
and values along the vertical axis.
Bar chart:
A bar chart displays data in the form of long rectangular horizontal bars. A
bar chart illustrates comparisons among individual items. In a bar chart,
categories are represented on the vertical axis and values are represented on
the horizontal axis.
Que 3 Explain the two methods to insert a chart.
Ans - Method 1:
Select the cells and
press the F11 key. Excel automatically creates a chart for us and a new Chart
tab appears along with the Sheet tabs.
Method 2:
Step 1: Select the cells within the table.
Step 2: Click on Insert tab on the Ribbon.
Step 3: Select the type of chart from the
Charts group. For example, Column
charts type.
Step 4: Now, select the chart subtype from the drop-down list. This creates the chart
on the current worksheet.
Que 4.
How will you change the chart type?
Ans - The Change Chart
Type command is used to change the type of the existing chart.
Step 1: Select the chart and click on Design tab.
Step 2: Click on Change Chart Type in the Type group. The Change Chart Type dialog box appears.
