) How many types of chart available in ms excel and how to use it?
Answers
Answer:
Types of Charts in Excel
List of Top 8 Types of Charts in MS Excel
Column Charts in Excel
Line Chart in Excel
Pie Chart in Excel
Bar Chart in Excel
Area Chart in Excel
Scatter Chart in Excel
Stock Chart in Excel
Radar Chart in Excel
Let us discuss each of them in detail –
You can download this Types of Charts Excel Template here – Types of Charts Excel Template
Chart #1 – Column Chart
In this type of chart, the data is plotted on columns; that is 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.
Select the Data and go to Insert Tab, then select Column Chart.
Column Chart Example 1
Then the Column Chart looks like as given below:
Column Chart Example 1-1
Chart #2 – Line Chart
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.
Select the Data and go to Insert Tab, then select Column Chart.
Line Chart Example 2
Then the Line Chart looks like as given below:
Line Chart Example 2-1
Chart #3 – Pie Chart
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.
Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
This is a circle-shaped chart that divides itself into various portions to show the quantitative value.
Select the Data and go to Insert Tab then, select Pie Chart.
Pie Chart Example 1
Then the Pie Chart looks like as given below:
Pie Chart Example 1-1
Chart #4 – Bar Chart
In the Bar chart, the data is plotted on the Y-axis. This is why this is called 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 a row chart.
Select the Data and go to Insert Tab, then select Bar Chart.
Bar chart example 4
Then the Bar Chart looks like as given below:
Bar chart example 4-1
Chart #5 – Area Chart
Area chart and the line charts are logically the same, but the difference that makes a line chart an Area chart is that the space between the Axis and the plotted value is colored and is not blank.
In the case of using the stacked area chart, this becomes difficult to understand the data as space is colored with the same color for the magnitude that is the same for various datasets.
Select the Data and go to Insert Tab, then select Area Chart.
Area Chart Example 1
Then the Area Chart looks like as given below:
Type #8 - Area Chart in Excel
Chart #6 – Scatter Chart
In the scatter chart in excel, the data is plotted on the coordinates.
Select the Data and go to Insert Tab, then select the Scatter Chart.
Scatter Chart Example 5
Then the Scatter Chart looks like as given below:
Type #8 - Scatter Chart in Excel
Chart #7 – Stock Chart
Such charts are used in stock exchanges or to represents the change in the price of shares.
Select the Data and go to Insert Tab, then select Stock Chart.
Stock Chart Example 1
Then the Stock Chart looks like as given below:
Type #8 - Stock Chart in Excel
Chart #8 – Radar Chart
The radar chart is similar to the spider web, and this is often called a web chat.
Select the Data and go to Insert Tab then, Under Stock Chart, select the Radar Chart.
Type #8 - Radar Chart in Excel
Then the Radar Chart looks like as given below:
Radar Chart Example 1-1
Answer:Following are the most popular Excel charts and graphs:
Clustered column chart.
Combination chart.
Stacked column chart.
100% stacked column chart.
Bar chart.
Line chart.
Number chart.
Gauge chart (Speedometer chart)
Explanation: