How can we help?

You can also find more resources in our Help Center.

20 terms

Excel Lesson 8: Working with Charts

STUDY
PLAY
Axis
A line that establishes a relationship between data in a chart; most charts have a horizontal x-axis and a vertical y-axis.
Chart
A graphical representation of data.
Chart area
The entire chart and all other chart elements
Chart layout
Specifies which elements are included in a chart and where they are placed.
Chart sheet
A separate sheet in the workbook that stores a chart.
Chart style
Formats the chart based on the colors, fonts, and effects associated with the workbook's theme.
Column chart
Chart that uses bars of varying heights to illustrate values in a worksheet.
Data label
Text or numbers that provide additional information about a data marker.
Data marker
A symbol that represents a single data point or value from the corresponding worksheet cell.
Data series
A group of related information in a column or row of a worksheet that is plotted on the chart.
Data source
Chart data.
Data table
A grid that displays the data plotted in the chart.
Embedded chart
After you select a chart type and style, the chart is inserted as an embedded chart in the center of the worksheet.
Exploded pie chart
When you pull one or more slices away from the pie in a pie chart to distinguish them
Legend
A list that identifies patterns, symbols, or colors used in a chart.
Line chart
Chart that is similar to a column chart, but where columns are replaced by pointsconnected by a line.
Pie chart
Chart that shows the relationship of a part to a whole.
Plot area
The graphical representation of all of the data series.
Scatter chart
Chart that shows the relationship between two categories of data. The data points are not connected by a line because they do not relate to each other the way they do in a
line chart.
Sparkline
Mini charts that you can insert into a cell.