Excel Charts

Flashcards covering chart types, chart elements, and creating charts in Excel.

_ charts are used when the order of the categories is not important.

These charts compare numerical values for several categories.

_ charts are similar to column charts, but are used in different situations.

These charts also compare numerical values for several categories, but are used when the category text is long or when showing 'Duration'.

_ graphs plot data as a series of points and link them to estimate values between recorded points.

These charts show trends - how one category changes compared to another.

_ charts turn quantities in a category into a percentage.

These charts show categories as proportions of a whole.

The first step in creating a chart is to _

Select the data values you want to place in it.

In a chart, _ are the lines used to plot data.

The vertical and horizontal lines against which data is plotted; the x-axis is the category axis, and the y-axis is the value axis.

The _ is the information used to make a chart.

The data selected to create the chart.

_ are the building blocks of values used when creating a chart

Row or column headings that make up the cells of values from the worksheet used to create the graph.

_ describe what is being shown in a chart

Lines of text used to describe the chart elements, including the chart, category axis, and value axis.

_ help with reading values from a graph more easily.

Incremental lines that may appear along each axis to help you read values from the graph.

A _ shows how each series is represented on a chart.

A cross-reference to show each series is represented in the chart; a key.

_ are the specific labels describing the values on a chart.

The actual values, percentages, or names given to a bar or segment in a chart.

A _ at the bottom of the chart displays the graphed information

The cells of values that are included at the bottom of the chart used to chart the graph.

To create a chart in Excel, select the data and then go to the _

Insert tab / Charts group.

The Design tab in Excel allows you to _

Change the features of the chart, such as titles, labels, legends, data tables, axes, and gridlines.