• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Lesson 22. Creating Charts > Charting Terminology

Charting Terminology

Before you start creating charts, familiarize yourself with the following terminology:

Data Series The bars, pie wedges, lines, orother 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 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 instance, charting the sales for Territory 1 versus Territory 2 would require two data series—one for each territory. Often, data series correspond to rows of data in your worksheet.

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

Axis One side of a chart. A two-dimensionalchart has an x-axis (horizontal) and a y-axis (vertical). The x-axis contains all 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 will show what each piece of the pie represents.

Gridlines Emphasize the y-axis or x-axisscale of the data series. For example, major gridlines for the y-axis will help you follow a point from the x- or y-axis to identify a data point's exact value.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint