explain the different types chart in spread sheet
Answers
The Pie Chart
A Pie Chart displays one series of data. A data series is a row or column of numbers used for charting. In the worksheet below, we have outlined a single data series. If we had selected multiple series for the Pie Chart, Excel would ignore all but the first.
The Column Chart
The Column Chart effectively compares a single set of data points, but it shines when comparing multiple series. Outlined in red, the image below shows the three data series we're charting. Notice that we do not include the totals in our data series.
The Line Chart
The Line Chart is especially effective in displaying trends. The vertical axis (Y-axis) always displays numeric values and the horizontal axis (X-axis) displays time or other category. The first image shows the Line with Markers chart of our single data series. Markers—the circles, squares, triangles, or other shapes which mark the data points—are optional, and Excel displays a unique marker in shape and/or color for each data series.
The Bar Chart
The Bar Chart is like a Column Chart lying on its side. The horizontal axis of a Bar Chart contains the numeric values. The first chart below is the Bar Chart for our single series, Flowers. When to use a Bar Chart versus a Column Chart depends on the type of data and user preference. Sometimes it is worth the time to create both charts and compare the results. However, Bar Charts do tend to display and compare a large number of series better than the other chart types.
The Area Chart
Area Charts are like Line Charts except that the area below the plot line is solid. And like Line Charts, Area Charts are used primarily to show trends over time or other category. The chart at left is an Area Chart for our single series.
The Scatter Chart
The purpose of a Scatter Chart is to observe how the values of two series compares over time or other category. According to Scatter Plots (U. of Illinois), "Scatter plots are similar to line graphs in that they use horizontal and vertical axes to plot data points. However, they have a very specific purpose. Scatter plots show how much one variable is affected by another. The relationship between two variables is called their correlation."
Other Chart Types
Excel offers other chart types, such as Stock, Surface, Doughnut, Bubble, and Radar. To locate a menu of all available chart types in newer Excel versions, begin to insert any chart type and click All Chart Types. The image below shows the menu that displays—menu may look different on your version of Excel.
PLEASE MARK IT AS BRAINLIEST.