Information Technology [3 Mark Questions]

Creating a Chart:
Here is a worksheet that shows the marks of students in a class subject wise. To create a chart, do the following:

1. Select the data that you want to show, including the column titles and the row labels.
2. Then click the Insert tab and in the Charts group, click the Column button. You could select another chart type, but column charts are commonly used to compare items.
3. After you click Column, you’ll see a number of column chart types to choose from. Click Clustered Column, the first column chart in the 2-D Column list.

A ScreenTip displays the chart type name, when you rest the pointer over any chart type. The ScreenTip also provides a description of the chart type and gives you information about that, when to use each one.
If you want to change the chart type after you create your chart, click inside the chart. On the Design tab under Chart Tools, in the Type group, click Change Chart Type and select another chart type.

The various types of charts in Excel are given below:
Line Chart: Data that is arranged in columns or rows on a worksheet can be plotted in a line chart. Line charts can display continuous data over time, set against a common scale and are therefore ideal for showing trends in data at equal intervals. In a line chart, category data is distributed evenly along the horizontal axis and all value data is distributed evenly along the vertical axis.
Pie Chart: Data that is arranged in one column or row only on a worksheet can be plotted in a pie chart. Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are displayed as a percentage of the whole pie.
Scatter Chart: Data that is arranged in columns and rows on a worksheet can be plotted in an XY (scatter) chart. Scatter charts show the relationships among the numeric values in several data series, or plots two groups of numbers as one series of XY coordinates.
Bar Chart: Data that is arranged in columns or rows on a worksheet can be plotted in a bar chart. Bar charts illustrate comparisons among individual items.
Area Chart: Data that is arranged in columns or rows on a worksheet can be plotted in an area chart. Area charts emphasize the magnitude of change over time and can be used to draw attention to the total value across a trend, e.g. data that represents profit over time can be plotted in an area chart to emphasize the total profit.

Various components or parts of chart are as follows:

1. X-axis Refers to a horizontal axis, which is also known as category axis.
2. Y-axis Refers to a vertical axis also known as value axis.
3. X-axis title Conveys the full details of the X-axis values.
4. Y-axis title Conveys the full details of the Y-axis values.
5. Data series Refers to a set of data that you want to display in a chart.
6. Chart area Refers to the total space that is enclosed by a chart.
7. Plot area Refers to the main region of the chart in which your data is plotted.
8. Chart title Denotes the type of data plotted in a chart.
9. Legend In a chart showing different data series, a unique color or pattern is assigned to each data series. This unique color of pattern is known as a legend.
10. Gridlines These are the horizontal and vertical lines within the plot area in a chart.
11. Data label Provides additional information about a value in the chart, that is coming from a worksheet cell.