Learn carefully and use them accordingly. We will illustrate each chart and its functionality with an example in this chapter. It has come with some advanced features and representation styles. Microsoft Excel introduce one more new chart called Treemap chart for 2016 and newer version. These are the most used charts of Excel that an Excel user usually requires. There is a list of basic and advanced level of charts used for different purposes to interpret the data. You can use them according to your data and analysis. Charts offered by ExcelĮxcel offers many charts to represent the data in different manners, such as - Pie charts, Bar charts, Line charts, Stock charts, Surface charts, Radar charts, and many more. Excel has a variety of charts, each with its own different functionality and representation style.

Graphical representation of data using charts makes complex data analysis easier to understand. This makes the process of analyzing data fast. The data represented through charts is more understandable than the data stored in an Excel table. Charts are the visual representation of data.Įxcel provides charts to take advantage of graphical representation. So, charts are a way to represent the data graphically and interpret the data easily. To see a menu of all available chart types in newer versions of Excel, click the down arrow by 'Charts' in the Charts section of the ribbon's Insert Tab.It is sometimes difficult to interpret the Excel data due to complexity and size of data. Other Chart TypesĮxcel offers other charts such as Stock, Surface, Doughnut, Bubble, and Radar. The series pair has a Positive Correlation if they increase similarly, and a Negative Correlation if they both decrease in like manner. See Scatter Charts with Lines to understand why this happens and how to fix it. Sometimes scatter charts with lines can be confusing if the line zig-zags and crosses itself. In general, markers work well when the number of data points is small, and smooth lines are often used with a large number of data points. Scatter charts come with or without markers, and data points can be connected with smooth or straight lines. The scatter chart is called the XY Chart because its data points are the intersection of two values on the X and Y-axis. The SCATTER Chart observes the relationship between two variables.

How do i make a pie chart in excel 2007