CLASS - 7 | CHAPTER-3 (Charts in Excel)

 SUBJECT: COMPUTER

CHAPTER-3

Chart in Excel

Understanding Charts

A chart is a graphical representation of data. Charts make it a lot more easier for us to analyze and interpret data. 

Elements of a Chart

Data Series -  The Data series is a group of related values, like all Data values in a Row or a Column of the Data sheet.

Chart Title -  The Chart Title, as the name suggests, gives you an idea about the topic of the chart.

Y-axis -  The Y-axis shows the value of plotted Data points. This is also called the Value axis.

X-axis -  The X-axis generally shows the category of plotted Data points. This is also called the category axis. A category axis becomes a time scale axis when the Axis Type is set to Date or Time axis.

Legends -  Legends are used to represent the Data series. These Legends are associated with a pattern or colour, which is associated with the series and placed on the Chart.

Various Chart Types

Column Charts -  In column charts, categories are typically organized along the horizontal axis (x-axis) and value along the vertical axis (y-axis).

Line Charts -  A Line charts shows a trend in data at equal intervals. Line charts are useful for depicting the change in a value over a period of time.

Pie Charts -  A pie chart shows the proportional size of the items included in a single data series.

Bar Charts -  Bar Charts are very similar to Column charts, the only difference is that bars are horizontal.

Steps to Create Charts

To create a chart is very easy task in Excel. You just need to click on the Insert tab and then select the chart type and sub type.

• Select the data from which you want to create the chart.

• Click on the Insert tab.

• Click on the Chart type button. A list of chart subtypes will be displayed.

• Click on the chart subtype.

Editing of Charts

You can also edit the chart to change the type or format the chart according to your requirements.

• Click anywhere in the chart.

• Click on the Chart Tools contextual tab.

• Click on the Change Chart Type button.

• The Change Chart Type dialog opens.

• In the left pane, select the chart type and in the right pane select the chart subtype.

• Click on the OK button

Changing the Chart Layout

The same chart can be presented in various layouts like Legend on the left, or at the bottom, with or without titles, etc.

• Click anywhere in the chart. You will see the Chart Tools contextual tab.

• Click on the chart Tools contextual tab.

• In the chart layout group, click on the More button. The various layouts will be displayed. Select the required layout.

• Select the chart style from the chart Styles gallery.

Adding the Chart Title

A chart title gives an idea about the topic of the chart. You can add the title to your excel chart to make it more meaningful.

• Click on empty are of the chart to which you want to add the chart title.

• Click on the layout tab.

• Click on the Chart Title button. A drop-down menu appears displaying option which specify how the chart title will be displayed on the chart.

• A text box containing the text “Chart Title” will be added to the chart. Replace the text in the text box with the text of the chart title.

    Worksheets

Worksheet 1  Multiple Choice Question (MCQs).

1. Which Axis is also known as Category axis?

1. Y-axis

2. X-axis

3. Z-axis

4. Circular axis
   
   

2. Which charts are useful for showing data changes over a period of time or for illustrating comparisons among items?

1. Pie Chart

2. Area chart

3. Column Chart

4. Scatter chart

3. Which option from the drop down menu will first resize the chart and then as a title above the chart area?

1. None

2. Centered overlay title

3. Above Chart

4. Below Chart

4. Which chart show trend in data at equal intervals?

1. None

2. Pie Char

3. Pie Char

4. Column Chart

5. What is used to represent Data series ?

1. Chart Title

2. Legends

3. X-axis

4. Y-axis

Worksheet 2  Write (T) for True and (F) for False against the statements. 

1. Y-axis is also called the Category axis. 

2. A category axis become a time scale axis when the Axis Type is set is set to Data axis.

3. The Y-axis shows the values of the plotted Data points.

4. Legends are used to represent the Data series.

5. A Spark line is a large chart in a worksheet cell.

Worksheet 3  Select the suitable words and fill in the blanks.

Chart title     Line Pie X-axis Y-axis Column

1. ________ charts are useful for showing data changes over a period of time or for illustrating comparisons among items.

2. A__________ chart shows trend in data at equal intervals.

3. A__________ chart shows the proportional size of items included in single data series.

4. The __________is also called the Category axis.

5. The ____________is also called the Value axis.

6. The ________give you an idea about the topic of chart.

Worksheet 4  Match the following:

Column A	Column B
Charts	Shows a trend in data at equal intervals.
Data Series	The best chart types for comparing multiple sets of value.
Legends	Used to represent the data series.
Line Chart	Shows the proportional size of the items included in a single data series.
Pie Chart	Represents data graphically.
Bar Chart	Gives us an idea about of related values, like all data values in a row or a column of the data sheet.
Chart Title	A name for a group of related values, like all data value in a row or a column of the data sheet.

Worksheet 4  Answer the following:

1. Explain about the various chart types.

2. Write about the axis of chart.

3. What are Data series and Legends in a chart?

4. What will happen if you change a value in the data from where you have created the charts?

5. What do you know about Spark lines?