Most of the tools in the Layout were -in a wayhidden in the previous Excel versions. Moreover, you are able make your own changes as you wish. You can also select a different color theme and have fun with hundreds of different style sets. You are not limited with these predefined style sets. All you need to do is to select the one that suits your needs. Like a pie chart, a doughnut chart shows the relationship of parts to a whole, but it can contain more than one data series.Ĭhart styles offer many professional color and design sets. As in a topographic map, colors and patterns indicate areas that are in the same range of values. (See Chapter 5.5.4.8 Correlation) In the left figure, as you see, there is a strong negative relation between the number of absences and final grade.Ī surface chart is useful when you want to find optimum combinations between two sets of data. Scatter charts are used when you have two or more variables and you want to search the relation between them. The segments represent individual parts which make up the total. A pie chart consists of a circle split into segments. On the other hand, for market shares or for the results of an election, you could prefer a Pie chart, etc. For example, for annual sales, because it’s easy to see the growth/shrink, you can select Column, Cylinder or Line. You may use different types of charts for different purposes.
0 Comments
Leave a Reply. |