One factor to consider as you want to choose the best type of chart in Excel is the relative strengths and weaknesses of each type of graph. One could, of course, write an entire book on this subject. However, May you find it useful to examine the strengths and weaknesses described in the paragraphs that follow to choose a graphic.
Graphic area charts
Areas plot point values using the data lines. Optionally, the model cell so that the accumulation of data are point values and areas of color between the lines.
With the two advantages you can view the trend of the first data set and the total of all data sets, and can often create data sets total implied.
For example, suppose you draw two sets of data in a graph: one for a total cost and benefits. In this situation, in fact, a third set of data – revenue – because the total data sets implicitly to create a third data set for total income.
Areas too, it is virtually impossible to compare the values of data points in the second and the data series. You can get a very good idea of the first set of data values of data points, however.
Cylinder, cone and pyramid Letters
Cylinder, cone and pyramid chart types have the same strengths and experience the same weaknesses as well as column and bar charts.
In addition, cylinder, cone and pyramid chart types, their three dimensions, which also suffer from a weakness. The new dimension, while interesting, it is often more accurate to compare various points of the given values.
Bubble Maps allow you to visually explore relationships between sets of data by processing the horizontal axis as the second value axis. To achieve this objective, the bubble charts plot pairs of data points.
For example, a bubble is income and the contribution of visual data in May suggests that people who earn more money, but only slightly increase their donations.
Bubble XY graphics cards, which also show the same information on the size of bubbles Excel with the values of a third data point.
Standing Up to the column charts
The column data tables to plot the different values of the bars, but to organize through the bars of a vertical axis calibrated values.
Accordingly, the column of graphics work really well when you want to see data on a point value of the whole question of the whole issue of comparing data and that data are periods of weather.
Doughnut Charts work similar to pie chart, the presentation of data in serial and concentric rings indicating the value of each data point as a segment, or biting the ring.
Compared to those graphs, charts gifts have an advantage: it can take more than one data series. In practice, that suffers the same deficiencies as pie charts: do not compare data between the values of the series.
They are limited to small data sets. Almost always, something that appears in a doughnut graph must be of a different type of graph.
Line plot maps in general the individual data points on a line, or using a different marker symbols or lines of different colors to distinguish data sets, and the use of a horizontal data category.
The graphics on the line de-emphasize the different data points, which work well for large data sets. With a line graph, you can draw thousands of data points. Moreover, all types of Excel charts, graphs tend to highlight the changes and trends in the values of data points that May be helpful.
However, the line graphs suffer from several shortcomings: a focus on each of the values of data points that can hide small data sets in an inappropriate manner and that it is impossible to compare the different data points, a tendency to show trends based on time that does not exist, and a tendency to show the relationship between the data sets that do not exist.
Pie charts, as almost everyone knows, the display of a single set of data and data points represent segments of a circle, or slices of cake.
All this means that people can compare the values of data points for the total of all values of points and it could be argued this is a force in general, these charts are not based, as it can display a small set of data.
Almost always, something that appears in a graph should be on a table.
Stock of letters on a plot prices opened high-low-close format, as seen in a newspaper or a television.
Although this type of chart shows the safety analysis technique, the type of graph can be useful even for non-safe price. You can use this table, for example, to draw daily temperatures.
Plot maps of a series of data in three dimensions, the network does not usually use colors to identify the data series, but rather to indicate the value varies axis.
The greatest strength of the surface is a graph that allows you to display with the same emphasis on the relationships within a set of data and data within a category.
A graph of the surface, however, suffers from two weaknesses: first, because the graph shows three-dimensional surface, it is easy for the topography of the plot area to hide data from valleys to peaks hide.
With a circulation of XY charts
Charts also known as XY scatter plot, it allows you to visually explore relationships between sets of data by processing the horizontal axis as the second value axis.
To do this, the graphics really intrigue XY pairs of data points. For example, an XY graph to trace the relationship between income and charitable donations.
The strength of an XY chart is that it allows you to explore the fundamental relationship, between two sets of data. In fact, the XY table is the only type of Excel chart that allows you to do so.