Understanding Charting Terminology

Charts enable you to create a graphical representation of data in a worksheet. You can use charts to make data more understandable to people who view your printed worksheets. Before you start creating charts , you should familiarize yourself with the following terminology:

  • Data Series The bars, pie wedges, lines, or other elements that represent plotted values in a chart. For example, a chart might show a set of similar bars that reflects a series of values for the same item. The bars in the same data series would all have the same pattern. If you have more than one pattern of bars, each pattern would represent a separate data series. For example, charting the sales for Territory 1 versus Territory 2 would require two data seriesone for each territory. Often, data series correspond to rows of data in your worksheet (although they can correspond to columns of data if that is how you have arranged the information in your worksheet).

  • Categories Categories reflect the number of elements in a series. You might have two data series that compare the sales of two territories and four categories that compare these sales over four quarters . Some charts have only one category, and others have several. Categories normally correspond to the columns in your worksheet, with the category labels coming from the column headings.

  • Axis One side of a chart. A two-dimensional chart has an x-axis (horizontal) and a y-axis (vertical). The x-axis contains the data series and categories in the chart. If you have more than one category, the x-axis often contains labels that define what each category represents. The y-axis reflects the values of the bars, lines, or plot points. In a three-dimensional chart, the z-axis represents the vertical plane, and the x-axis (distance) and y-axis (width) represent the two sides on the floor of the chart.

  • Legend Defines the separate series of a chart. For example, the legend for a pie chart shows what each piece of the pie represents.

  • Gridlines Typically, gridlines appear along the y-axis of the chart. The y-axis is where your values are displayed, although they can emanate from the x-axis as well (the x-axis is where label information normally appears on the chart). Gridlines help you determine a point's exact value.



Microsoft Office 2003 All-in-One
Microsoft Office 2003 All-in-One
ISBN: B005HKSHB2
EAN: N/A
Year: 2002
Pages: 660
Authors: Joe Habraken

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net