CREATING GRAPHS

• Charts allow you to illustrate your workbook data graphically, which makes it easy to visualize comparisons and trends.
• Columns use vertical bars to represent data. They can work with many different types of data, but they are most frequently used for comparing information.
• Lines are ideal for showing trends. The data points are connected with lines, making it easy to see whether values are increasing or decreasing over time.
• Pie makes it easy to compare comparisons. Each value is shown as a slice, so it's easy to see which values make up the percentage of a whole.
• Bar works just like column charts, but they use horizontal rather than vertical bars.
• Area is similar to line charts, except the areas under the lines are filled in.
• Surfaces allow you to display data across a 3D landscape. They work best with large data sets, allowing you to see a variety of information at the same time.
• The Vertical Axis or Y-Axis, is the vertical part of the chart. It measures the value of the columns.
• The Horizontal Axis or X-Axis is the horizontal part of the chart. It identifies the categories in the chart.
• The Legend identifies which data series each color on the chart represents.
• The Data Series consists of the related data points in a chart.