explain the main charts types avilable in MS-Excel
Answers
Answer:
Explanation:
Graph Type #1 – Column Charts in Excel
In this type of chart, the data is plotted on columns that are why this is called a column chart.
A column chart is a bar-shaped chart that has a bar placed on the X-axis. This type of chart in excel is called a column chart because the bars are placed on the columns. Such charts are very useful in case we want to make a comparison.
Graph Type #2 – Line Chart in Excel
Line charts are used in case we need to show the Trend in data. They are more likely used in analysis rather than showing data visually.
In this type of chart, a line represents the data movement from one point to another.
Graph Type #3 – Pie Chart in Excel
A pie chart is a circle shaped chart that is capable of representing only one series of data. A pie chart has various variants that are a 3d chart and doughnut charts.
This is a circle shaped chart that divides itself into various portions to show the quantitative value.
Graph Type #4 – Bar Chart in Excel
In the Bar chart, the data is plotted on the Y-axis. This is why this is called as a bar chart. As compared to the column chart, these charts use the Y-axis as the primary axis.
This chart is plotted on rows that are why this is called as a row chart.