CIS111E Chapter 3 Charts

  1. Chart
    Is a visual representation of numerical data that compares data and helps reveal trends or patterns to help people make informed decisions.
  2. Chart Area
    Contains the entire chart and all of its elements, including the plot area, titles, legend, and labels.
  3. Plot area
    Is the region containing the graphic representation of the values in the data series.  Two axes form a border around the plot area.
  4. X-axis
    Is a horizontal border that provides a frame of reference for measuring data horizontally.
  5. Y-axis
    Is the vertical border that provides a frame of reference for measuring data vertically.
  6. Legend
    A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series in a chart.
  7. Data Point
    Each cell containing a value
  8. Data Series
    A group of related data points that display in row(s) or column(s) in the worksheet.
  9. Category Labels
    Row and column labels (such as job titles, years, growth, etc.)
  10. Chart column
    Display data vertically in columns.

    Create a column charity compare values across difference categories.
  11. Clustered column chart
    Compares groups-or clusters-of columns set side by side for easy comparison.
  12. Stacked column chart
    Show the relationship of individual data points to the whole category.  (Use the stacked column chart when you want to compare total values across categories, as well as to display the individual category values).
  13. 100% stacked column chart
    Converts individual data points into percentages of the total value.
  14. Bar Chart
    Compares values across categories using horizontal bars. 

    The horizontal axis display values, and the vertical axis display categories.
  15. Line Chart
    Displays lines connecting data points to show trends over equal time periods.
  16. Pie Chart
    Shows each data point as a proportion to the whole data series.

    Use a pie chart when you want to convey percentage or market share.
  17. X Y (scatter) chart
    Shows a relationship between two numerical variables using their X and Y coordinates.
  18. Stock Chart
    Shows fluctuations in stock changes.

    Black fill: opening price was higher than the closing price

    White fill: closing price was higher than the opening price

    A line blow the rectangle indicates that the lowest trading price is lower than the opening and closing prices.

    A line above the rectangle indicates the highest trading price was higher than the opening and closing prices.
  19. Chart Sheet
    A chart in a separate worksheet
  20. Chart Element
    Is a component that completes or helps clarify the chart.
  21. Chart Style
    A collection of formatting that controls the color of the chart area, plot area, and data series.
  22. Chart filter
    Controls which data series and categories are visible in a chart.
  23. Spark Line
    Is a small line, column, or win/loss chart contained in a single cell.
Card Set
CIS111E Chapter 3 Charts
Chapter 3 Charts