explain any 5 types of chart in ms excel
Answers
Answer:
- The Pie Chart
A Pie Chart can only display one series of data. A data series is a row or column of numbers used for charting. Excel uses the series identifier (column or row heading) as the chart title (e.g. Flowers) and displays the values for that series as proportional slices of a pie. If we had selected multiple series of data, Excel would ignore all but the first series. In the worksheet below, we have outlined in red a single data series in a spreadsheet
2.The Column Chart
The Column Chart very effectively shows the comparison of one or more series of data points. But the Clustered Column Chart is especially useful in comparing multiple data series.
3.The Line Chart
The Line Chart is especially effective in displaying trends. In a Line Chart, the vertical axis (Y-axis) always displays numeric values and the horizontal axis (X-axis) displays time or other category.
4.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.
5.The Area Chart
The 2-D area chart with one series
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.
Hope this helps you
Plz mark it as brainliest answer
Answer:
Column Chart
A Column Chart typically displays the categories along the horizontal (category) axis and values along the vertical (value) axis. To create a column chart, arrange the data in columns or rows on the worksheet.
A column chart has the following sub-types −
Clustered Column.
Stacked Column.
100% Stacked Column.
3-D Clustered Column.
3-D Stacked Column.
3-D 100% Stacked Column.
3-D Column.
Line Chart
Line charts can show continuous data over time on an evenly scaled Axis. Therefore, they are ideal for showing trends in data at equal intervals, such as months, quarters or years.
In a Line chart −
Category data is distributed evenly along the horizontal axis.
Value data is distributed evenly along the vertical axis.
To create a Line chart, arrange the data in columns or rows on the worksheet.
A Line chart has the following sub-types −
Line
Stacked Line
100% Stacked Line
Line with Markers
Stacked Line with Markers
100% Stacked Line with Markers
3-D Line
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 shown as a percentage of the whole pie. To create a Pie Chart, arrange the data in one column or row on the worksheet.
A Pie Chart has the following sub-types −
Pie
3-D Pie
Pie of Pie
Bar of Pie
Doughnut Chart
A Doughnut chart shows the relationship of parts to a whole. It is similar to a Pie Chart with the only difference that a Doughnut Chart can contain more than one data series, whereas, a Pie Chart can contain only one data series.
A Doughnut Chart contains rings and each ring representing one data series. To create a Doughnut Chart, arrange the data in columns or rows on a worksheet.
Bar Chart
Bar Charts illustrate comparisons among individual items. In a Bar Chart, the categories are organized along the vertical axis and the values are organized along the horizontal axis. To create a Bar Chart, arrange the data in columns or rows on the Worksheet.
A Bar Chart has the following sub-types −
Clustered Bar
Stacked Bar
100% Stacked Bar
3-D Clustered Bar
3-D Stacked Bar
3-D 100% Stacked Bar
Area Chart
Area Charts can be used to plot the change over time and draw attention to the total value across a trend. By showing the sum of the plotted values, an area chart also shows the relationship of parts to a whole. To create an Area Chart, arrange the data in columns or rows on the worksheet.
An Area Chart has the following sub-types −
Area
Stacked Area
100% Stacked Area
3-D Area
3-D Stacked Area
3-D 100% Stacked Area