5. Answer the questions.
a) What is a chart?
b) What are the uses of charts?
c) Define the following chart elements.
(i) Data series
(ii) Data table
(iii) Data labels
(iv) Legend
d) List the steps used to change the layout of a chart.
e) How is chart area different from plot area?
f) Give differences between the following types of charts.
(i) Pie chart and Doughnut chart
(ii) Line chart and Area chart
(iii) Column chart and Bar chart
g) How will you resize a chart?
h) What do you mean by sparkline? Explain the three types of sparklines?
Answers
Answer:
ans no 1 Chart is a tool you can use in Excel to communicate data graphically. ChaPie charts are used to compare the contribution of each value to a total. Doughnut charts are used to compare the contribution of each value to a total. ... Doughnut chart can contain multiple numeric data series. Size of the pie slices are used to indicate the values.rts allow your audience to see the meaninSelect the chart you want to change. To quickly change the char behind the numbers, and they make showing comparisons and trends much easier. In this lesson, you'll learn how to insert charts and modify them so they communicate information effectively.
2.A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.
3. 1. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits. Charts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word.
2. A data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. A good example of a data table employs the PMT function with different loan amounts and interest rates to calculate the affordable amount on a home mortgage loan.
3. Data labels are used to display source data in a chart directly. They normally come from the source data, but they can include other values as well, as we'll see in in a moment. ... You can even select a single bar, and show just one data label. In a bar or column chart, data labels will first appear outside the bar end.
4.A Legend is a representation of legend keys or entries on the plotted area of chart or graph which are linked to the data table of the chart or graph. By default, it may show in the bottom or right side of the chart. The data in a chart is organized with the combination of Series and Categories.
d) Select the chart you want to change. Click the Design tab under Chart Tools. To change the chart layout, click the Quick Layout button, and then click the layout you want. To quickly change the chart style and colors, click the Chart Styles button (New!)
e) Chart area includes charts to represent the data, on the other hand, the plot area includes only the graphical representation of the chart. Since the chart area occupies more space, it is bigger in size whereas the plot area occupies only less space and is small in size.
f)1.Pie charts are used to compare the contribution of each value to a total. Doughnut charts are used to compare the contribution of each value to a total. ... Doughnut chart can contain multiple numeric data series. Size of the pie slices are used to indicate the values.
2.Line charts are usually for observing trends over a certain period of time. The Y axis shows numeric values and the X axis represents the key measurements. ... Area charts are ideal for indicating a change among different data sets. A line chart connects discrete but continuous data points by using straight line segments.
3.Bar and column charts display data in rectangular bars — the longer the bar, the larger the value. A bar chart plots the variable value horizontally, and the fixed dimension, such as time, vertically. A column chart plots the variable value vertically, and the fixed dimension horizontally.
g) By default, a chart is moved and sized with cells. When you change the size of cells on the worksheet, the size of the chart adjusts accordingly. You can change this positioning option if you don't want to move or resize the chart together with the worksheet cells.
h) A sparkline is a very small line chart, typically drawn without axes or coordinates. ... There are three different types of sparklines: Line, Column, and Win/Loss. Line and Column work the same as line and column charts.
chart is an effective way to display data in a pictorial and graphical form charge make it easier to show a reason and growth relationship among the values and trends.
components of chart are
chart area ,category axis, value axis, data series, category name, plot area ,legend, Chart title, gridlines.