primary vertical axis that describe the chart data. Bar chart Data graphed as a series of bars. Category The division of data within a series. Categor...
Vocabulary Axes titles Titles on the primary horizontal axis and the primary vertical axis that describe the chart data. Bar chart Data graphed as a series of bars. Category The division of data within a series. Category labels Text displayed on the x-axis. Chart A visual representation of worksheet data. Chart Area The blank portion of a chart. Chart title Describes what is charted. Column chart Data graphed as a series of vertical bars. Data labels Labels that identify each value in the data series. Data series A set of related numerical data plotted on a chart. Legend Corresponds to the category labels in a pie chart and series names in other chart types. Line chart Data graphed using a continuous line. Major gridlines Gridlines that mark the major intervals on an axis. Pie chart Data graphed as slices of a circular pie. Plot Area The part of the chart that displays data. Primary horizontal axis Horizontal axis that contains category labels. Primary vertical axis Vertical axis that contains labels. Series name The label that identifies the data series. Slice Part of a pie chart that represents one value from the series. Sparklines Mini charts that can be displayed in a cell.
Excel Commands Above Chart Adds a chart title above the chart. Found in DESIGN j Add Chart Element j Chart Title. Change Chart Type Displays options for changing the chart type. Found on the DESIGN tab. Copy Places the selected chart on the Clipboard. Found on the HOME tab. Column Sparkline Inserts a column chart within a single cell. Found on the INSERT tab. Data Labels Adds data labels to a chart. Found in DESIGN j Add Chart Element. Edit Data Starts Excel and displays the workbook containing the chart. Found on the DESIGN tab in Word. Format Selection Displays a Format dialog box used to format a chart object. Found on the FORMAT tab. Insert Column Chart Displays a dialog box used to create a column chart. Found on the INSERT tab. Insert Line Chart Displays a dialog box used to create a column chart. Found on the INSERT tab. Insert Pie or Doughnut Chart Displays options for creating a pie chart. Found on the INSERT tab. Legend Displays options for modifying the legend. Found in DESIGN j Add Chart Element. Line Sparkline Inserts a line chart within a single cell. Found on the INSERT tab. Move Chart Displays a dialog box used to move a chart to a new sheet. Found on the DESIGN tab. Page Layout Displays the worksheet in Page Layout view. Found on the VIEW tab. Paste Places the most recently copied chart into a document. Found on the HOME tab. Paste Options Displayed when contents of the Clipboard are placed in cells. Used to link cells between sheets. Primary Horizontal Adds an axis title to the horizontal axis. Found in DESIGN j Add Chart Element. Primary Vertical Adds an axis title to the vertical axis. Found in DESIGN j Add Chart Element. Print Prints a copy of the worksheet. Found in Backstage view. Refresh Data Updates linked data. Found on the DATA tab. Also found on the DESIGN tab in Word. Select Data Displays a dialog box used to add labels to data in a chart. Found on the DESIGN tab.
Switch Row/Column Switches data charted on the horizontal axis to the vertical axis and vice versa. Found on the DESIGN tab. Themes Displays a gallery of themes. Found on the PAGE LAYOUT tab. Win/Loss Sparkline Inserts a line chart within a single cell. Found on the INSERT tab.
