What is Chart and Types of Chart in MS Excel?

Charts in Excel

Charts in Excel visual representation of the data in your worksheet. A chart is a very powerful tool that will help you to visualize data in different formats. A large data is summed up into a chart to get a quick view of the data. It is very important to select the right charts in Excel while presenting your large set of data. Building a chart is not a difficult task but the difficulty comes when you have to select which chart you want to build.
 
Charts help you to analyze your business reports and take quick and effective steps and decisions. Where do you find Charts in Excel or How will you insert Charts in Excel will be your next question. Well, Charts are located in the Insert tab of the Excel and you have a specific group named as Charts which will show you all the different forms of charts that are already available in Excel. It means they are the already in-built charts in Excel.

What are the types of charts that are available in Excel?

There are around 14 types of charts that are available in Excel. Some of the charts are explained in detail below:

1. Column chart: Column charts are one of the most used Charts in Excel. These Charts are used in making presentations and dashboards. These charts are usually used when we want to compare our data. In this chart you can compare one or more data sets. Column charts have two axis to represent the data. The X-axis i.e. the Horizontal Axis usually represents the Categories and the Y-axis i.e. the Vertical Axis usually represents the Values. The Column Charts in itself has different types of Column Charts, they are as follow: 2-D Column Charts, 3-D Column Charts. 2-D Column Charts are also called as Clustered Charts.

2. Bar Charts: Bar Charts too offer comparison for more than one data set. However, Bar charts are the opposite of the Column charts in terms of the look. Bar Charts too have two Axis to represent the data. The X-axis i.e. the Horizontal Axis represents the Values and the Y-Axis i.e. the Vertical Axis represents the Categories. Bar charts stretches from left to right while plotting the data. Bar Charts too have types like 2-D Clustered Charts, 3-D Clustered Charts, Stacked bar charts. There are different shapes as well to represent the data like the Horizontal Cylinder, Cone, Pyramid shapes.

3. Line Charts: Line Charts are the most frequently used charts. They are used mostly when you want to plot or compare the time series in the charts or to show the Trends. Here too there are two Axis with X-axis i.e. the Horizontal Axis representing the time or Category and the Y-Axis i.e. the Vertical Axis representing the numeric value. The Line Charts also have types like Line and line with markers, Stacked line, 3-D line.

4. Pie Charts: The Pie Charts are represented in Percentage. Pie Charts are taken into consideration when you have only single data. There are no negative Values. Pie charts too have its sub types like 3-D Pie Charts, Pie of Pie, Bar of Pie.

5. XY Scatter Chart: Scatter Charts also have two axis. This charts basically combines values of X-Axis and Y-Axis into a single point. They are scattered all around the charts so they are known as Scatter Charts. The Scatter Charts shows how much one variable is affected by another variable. The relation between these two variable are known as correlation. There are two types of correlation : Positive Correlation and Negative Correlation.  We can say there is a Positive Correlation when we see an upwards trend in the data i.e. the data move upwards from left to right. Negative correlation is when there is a downwards fall in the data i.e. the data falls downwards from left to right.

6. Area Chart: Area charts are more like Line charts. The Area charts too are used to show trends or time series. We have three types of Area charts like the Area chart, the stacked Area Chart, The 100% stacked Area Chart. The area chart is not an effective chart compared to the other charts that are available. The Area Chart also shows the relationship of parts to a whole.

7. Doughnut Chart: Data that is arranged in rows or columns only those data can be shown in the Doughnut Chart. Doughnut charts are similar like the Pie Charts but it contains more than one data. This Charts are not easy to read and so they are used less. A Doughnut Charts contains rings and each ring represents one data. We need to have our data arranged in Rows and Column in order to have a Doughnut Chart.

8. Radar Chart: Radar Charts are used for comparing the aggregate values of the several data. They are also known as Spider charts. It is very unusual type of chart and audience or the people find it difficult to understand. It becomes difficult to read these charts are so are less preferred. However one of the advantage of these chart is that it can handle more than one data series.

9. Stock Charts: As the name itself states that the Stock Charts represents the Stock Price. Stock Charts help us to show our calculation on annual temperature, annual rainfall. Stock chart too has its sub types High-Low-Close, Open-High-Low-Close, Volume-High-Low-Close, Volume-Open-High-Low-Close.

10. Combo Charts: Combo charts combines two or more different types of charts together in order to make our understanding easy.  It is easier to read. It is necessary that our data should in rows and column to create a Combo Chart. Following are the sub types of Combo Charts: Clustered Column-Line, Clustered Column- line on Secondary Axis, Stacked Area- Clustered Column, Custom Combination.

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.

MS Excel in Hindi

Pivot Table in Excel


Related Blog

  • Types of Charts
  • Create a Chart in 30 Seconds
  • Pie Chart in Excel
  • Line Chart in Excel
  • Column Chart in Excel
  • Scatter Chart in Excel
  • Bar Chart in Excel
  • Data Series in Excel
  • Area Chart in Excel
  • Trend line in Excel
  • Spark line in Excel
  • Thermometer Chart
  • Gantt Chart
  • Pareto Chart

Follow Excel Superstar

Excel Superstar on Facebook

Excel Superstar on Pinterest

Excel Superstar on twitter

Excel Superstar on google-plus