Excel Lesson 8: Working with Charts

20 terms by stprice 

Create a new folder

Advertisement Upgrade to remove ads

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.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set