Chapter 4

Combination Chart

A _____________________________ displays two different types of data by using multiple chart types in a single chart object. They can enhance the understanding of data when the scale of data being charted varies greatly.

Trendline

A ______________________is a line that uses current data to show a trend or general direction of the data.

1. support or refute assertions 2. clarify info 3. help the audience understand trends

Charts typically do what 3 things?

Major Gridlines

Gridlines at the designated label values

Minor gridlines

Gridlines between the label values

1. the chart conveys an accurate and clear message 2. the audience can understand the chart 3. chart is visually appealing

what are the 3 important reasons by chart design is important?

Chart sheet

A __________________________ is a special worksheet that is dedicated to displaying chart objects

Scatter Chart

A ________________________ also called XY, is a particular type of chart that conveys the relationship between two numeric variables. This type of chart is very common as a statistical tool depicting the correlation between the two variables.

Data Series

A ________________________ is a group of related data values to be charted.

Data point

A _________________________ is an individual data value in a given series

Area Chart

An ______________________ is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend. (x-axis is usually a time sequence)

Embedded chart

An _____________________________ exists as an object on the same worksheet with the data

Embedded

By default, Excel charts are ________________ in a worksheet. Thus, the chart will be resized if the underlying rows or columns are changed (can be changed through "size & properties")

-layouts -styles -labels -colors

Chart changes can be made by modifying what?

Pie chart

For a __________________, you need two data series: the labels and a set of corresponding values

Left, Right

For a scatter graph, it is standard to have the x-axis data in the __________ column, and the y-axis data in the ____________ column.

True

T/F: When the parts on a chart are labeled, a legend is not necessary.

Legend

The _____________________ is an index within a chart that provides info about the data

Quick Analysis

The ______________________________ tool is a contextual tool that appears when you select data in a worksheet and offers single-click access to formatting, charts, formulas, pivot tables, and s[arklines.

Recommended Charts

The _______________________________ feature quickly analyzes a selection in a worksheet and recommends chart types that best fit your data

Textual information

The addition of _______________________ helps the audience understand the meaning of your chart.

Line Chart

To create a _________________________, you need to have at least one set of labels and at least one set of corresponding data, but it is possible to have multiple data series.

- chart title - axes title - legend - data labels

What 4 things enhance a textual chart?

1. Location of chart 2. type of chart 3. general layout and style 4. what data you'll be using

What are the 4 things you must consider before making your chart?

1. Users do not understand content 2. Too much info 3. Incorrect chart type 4. Chart is difficult to read 5. Misleading or incorrect info or lableing

What are the 5 common issues with developing charts in Excel?

1. within an existing worksheet; an embedded chart 2. on a separate worksheet; a chart sheet

What are the two general locations for a chart?

Pictures and shapes

What two objects can be added to a chart?

Pie Charts

_________________ are commonly used for depicting the relationships of the parts to the whole.

Data Bars

___________________ are graphic components that are overlaid onto data in worksheet cells

Sparklines

____________________ are small charts that are embedded into cells in a worksheet, usually beside the data, to facilitate quick analysis of trends.

Gridlines

_____________________ are the lines that go across charts to help gauge the size of the bars, columns, or data lines

Bar Charts

_____________________ are useful for working with categorical data. Compares data horizontally.

Column Charts

_______________________ are useful for comparing data sets that are split into categories. They are also useful for showing categories over time where each column represents a unit of time.

Line Charts

________________________ help to convey change in data over a period of time

Stacked bar charts

____________________________ can be useful when you want to see how the individual parts add up to create the entire length of each bar. This should be considered when the sum of the data values is as important as the individual items

Data visualization

______________________________ is the graphical presentation of data with a focus on qualitative understanding