Elements
Types of Charts
Sheet & Chart Design
Formula Review
Miscellaneous
100

Another name for the x-axis

Horizontal Axis

100

Compares sizes of pieces as part of a whole

Pie Chart

100

Can be used to change the size of the chart

Sizing Handles

100

Adds or totals

SUM

100

Anther name for Vertical Axis

Y

200

The area inside the horizontal and vertical axes

Plot area

200

Compares object levels using a horizontal format

Bar Chart

200

The term for double clicking to expand a column width

Autofit

200

Calculates the average

AVERAGE

200

3-D charts contain a Y axis, X axis and a...

Z axis
300

The purpose of this is to identify

Legend

300

The default chart type in Excel. Compares object levels using a vertical format.

Column Chart

300

Two keyboard keys that allow you to create a line break in a cell

Alt + Enter

300

Finds the highest in a range

MAX
300

Each value in a cell you select for your chart, represented by a data marker

Data point

400

A collection of related data points

Data Series

400

Shows trends over time. Best for dates in axis.

Line Chart

400

The term for changing the axis numbers and therefore the appearance of the chart

Scale the axis

400

Finds the lowest in a range

MIN

400

These keyboard keys will allow you to toggle between value view and formula view

Ctrl + ~

500

Visually represents each data point

Data Marker

500

Shows a comparison, does one effect the other? 

Scatter Plot

500
The term when you use a text box and shape (such as an arrow) to call out something in a chart

Annotate the chart

500

Enters the total number of values in a range

COUNT

500

Every formula starts with...

=
M
e
n
u