Excel Functions Tutorials
- Excel Charts
- Types of Charts in Excel
- Area Chart in Excel
- Bubble Chart in Excel
- Chart Templates in Excel
- Change Chart Style in Excel
- Calendar Template in Excel
- Inventory Template in Excel
- Clustered Bar Chart in Excel
- Clustered Column Chart in Excel
- Column Chart in excel
- Combination Charts in Excel (Combo)
- Excel Combo Chart
- Control Charts in Excel
- Doughnut Chart in Excel
- Dynamic Chart in Excel
- Excel Chart Wizard
- Flow Chart in Excel
- Flowchart Excel Examples
- Funnel Chart in Excel
- Gantt Chart in Excel
- Gantt Chart Example
- Gauge Chart in Excel (Speedometer)
- Graphs vs Charts
- Histogram Excel Chart
- How to Make Graph / Chart in Excel?
- Legends in Excel Chart
- Line Graphs / Charts in Excel
- Line Chart Examples
- Marimekko Chart in Excel (Mekko)
- Normal Distribution Graph in Excel
- Organization Chart in Excel
- Pareto Chart in Excel
- Pie Chart in Excel
- Make Pie Chart in Excel
- Pivot Chart in Excel
- Radar Chart in Excel (Spider Chart)
- Stacked Chart in Excel (Column, Bar & 100% Stacked)
- Stacked Bar Chart in Excel
- Stacked Column Chart
- Stock Chart in Excel
- Scatter Plot in Excel (Chart)
- Tornado Chart in Excel
- Dot Plots in Excel
- 3D Plot in Excel
- 3D Scatter Plot in Excel
- Standard Deviation Graph in Excel
- S Curve in Excel
- Waterfall Chart in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
Excel Chart Types (Table of Contents)
Types of Charts and Graphs in MS Excel
Every situation demands a specific type of presentation and to cater to this need we have a lot of graphs types that can be created as per the situation or presentation type. In excel we can create the graphs and choose the type of graphs as per our need.
In excel we can create the chart type like bar charts, column charts, pie charts, line charts and many more types of charts. Some of these types are easy to create and some need a little more efforts to show the data visually.
In excel we have various type of charts that can be used for various graphical representation situations. The charts that can be created in excel are 2d charts and 3d charts. The difference that is between the 2d and 3d chart is that the 3d chart uses the three axis that is x, y, and z to represent the data
Top 8 Types of Charts & Graphs in MS Excel
Below are the Top 8 Types of graphs in Excel.
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.
- Select the Data and go to Insert Tab then, select Column Chart.
- Then the Column Chart looks like as given below:
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.
- Select the Data and go to Insert Tab then, select Column Chart.
- Then the Line Chart looks like as given below:
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.
- Select the Data and go to Insert Tab then, select Pie Chart.
- Then the Pie Chart looks like as given below:
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.
- Select the Data and go to Insert Tab then, select Bar Chart.
- Then the Bar Chart looks like as given below:
Graph Type #5 – Area Chart in Excel
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 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.
- Then the Area Chart looks like as given below:
Graph Type #6 – Scatter Chart in Excel
In the scatter chart, the data is plotted on the coordinates.
- Select the Data and go to Insert Tab then, select Scatter Chart.
- Then the Scatter Chart looks like as given below:
Graph Type #7 – Stock Chart in Excel
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.
- Then the Stock Chart looks like as given below:
Graph Type #8 – Radar Chart in Excel
The radar chart is similar to the spider web and this is often called as a web chat.
- Select the Data and go to Insert Tab then, Under Stock Chart select Radar Chart.
- Then the Radar Chart looks like as given below:
How to Use Charts in Excel?
Below are the steps to use charts in excel.
Step 1: The first step will be to organize the data in such a way that the data can be plotted on an X axis and Y axis. If in case, we have data that has more than one columns of numeric value then this should be emphasized that the column that has Header should be on the corner left.
Step 2: After we have organized the data than we need to choose the best type of chart that will suit our requirement.
We can choose from a large available list of charts.
Step 3: After we have selected the chart type than we can add numerous type of chart elements that will help in understanding the chart easily.
Step 4: If we have some changes in the data that we can also change the data source of the chart by using the “data source” option.
If we have decimal value in the data set than we need to add “data labels” else this type of graph will not be easy to understand.
Things to Remember
- If we copy a chart from one location to another location than the data source will remain the same. This means that if we make any changes to the data set than both the charts will change, the primary one and the copied one.
- For the stock chart, there must be at least two data sets.
- A pie chart can only be used to represent one series of data. They cannot handle two data series.
- To keep the chart easy to understand we should restrict the data series to two or three, else the chart will not be understandable.
- We must add “Data labels” if we have decimals values to represent. If we do not add data labels than the chart cannot be understood with accurate precision.
This has been a guide to Types of Charts in Excel. Here we discuss top 8 types of graphs in Excel including Column Chart, Line Chart, Scatter Chart, Radar Chart, etc along with practical examples and downloadable excel template. You may learn more about excel from the following articles –