Area Charts in ExcelĪrea charts is excel will help you to graphically find the size of each category. And the XY Chart is for paired data to see the similarities among the grouped data.
#Make a pie chart in excel 2007 series#
The main difference between XY Chart and Line Chart is, Line Chart is used for time series data to see the changes over the time period. Some times we may not find any pattern or relationship in the data.
If they are opposite direction, we will see the negative relation ship. When you have two dimensional data, if both the dimensions are in the same direction (increase or decrease), we will find the positive relation ship. Following is another sample, you can see the positive relationship among the data points. We can not find any pattern or relationship in this data. Here is an example data (heights and weights of a random sample), see how it is distributed in the XY Chart. We need two axes data values (co-ordinates) to plot the scatter chart. Usually independent variables on x-axis and depending variables on y-axis. Scatter chart is useful if you are analyzing the data.Scatter Charts are helpful for Statistical or Engineering applications to see the data patterns. You can plot scatter with huge data and see how the data is plotted and the pattern. XY Charts in Excel are very helpful if you have paired or grouped set of data. Here are the Line Charts for the above time series data, we can quickly understand the change by looking at the line charts. Here is the example time series data table: Year We can use Le charts for studying Yearly data, Quarterly, Periodic, Monthly, Weekly, Daily and Hourly change in the data. Also helpful to understand time series data to forecasting.įollowing is the time series data for store, we can plot the Line chart and quickly understand the change of the metrics in different time periods. We can see the trend for different time frames or time periods using line charts in Excel. Line chart are useful for trend analysis. The following examples will show you data for few demographic variables of market research survey of 950 responses, you can quickly understand the data by looking at the Pie charts: Incom For example, you can show the percentages of few demographic categories in the pie chart to understand how each one in contributing. Pie charts in excel are good for showing proportional data. You can see the columns chart and easily understand and compare its sales in 20. For example, you can compare the 10 categories how they are performing in this year compares to the last year.įollowing is the data for 10 Categories of a Store and its sales in 20. You can compare the different metrics of over different time periods. If you have group of categories and want to compare the categories, you can choose Columns charts.
Here is the bar chart for the ranking data for 10 categories.Ĭolumn charts are suitable for comparative data analysis. Table: Top 10 Countries By Milk Production in 2011. Or if you have ranking type of data and you can use Bar chart to quickly understand the figures.įollowing are the example data and charts, you can clear and quickly interpret the data by looking at the data. For example, if you have the data for 10 categories and want to see how each category is performing. Bar Charts in Excelīar Charts in Excel are suitable if the data is categorical or ranking data. We will see each type of charts and when to use a particular chart and what type of data is suitable for a specific Chart Type. And Column Charts is having Clustered Column, Stacked Column and 100 % Stacked Column, etc. For example, Stock charts will be used most in the financial marketing functions and bubble charts are useful to study the competitive data analysis.Īnd in each chart type, we have different sub types, like Bar chart is having Clustered Bar, Stacked Bar and 100 % Stacked Bar Sub Chart types. And the other chars will be used based on the function. Pie, Column, Line, Bar, Area, and XY Scatter are most frequently used charts in Excel. There are verity of charts available in excel to deal with different kinds of data.
#Make a pie chart in excel 2007 how to#
And we will see how to choose the right chart for data analysis and reporting. Chart Types in Excel – Choosing best chart for Data Analysis session will discuss about different charts available in Excel like Bar Charts, Column Chart, Pie chart, Line Chart and other chart Types.
0 kommentar(er)
