Charts
Graphic elements that illustrate data.
Charts
This tool displays chart types that are appropriate for the selected data source.
Quick Analysis Tool
An _____________pie chart moves one slice away from the others as if someone were taking the piece away from the pie
Exploded
Because a chart is linked to its ___________source, any changes in the data source values will be reflected in the chart.
data
A ___________column chart displays the data series values in separate columns side by side so that you can compare the relative heights of values across categories.
clustered
A _____________ chart presents data in a circle graph divided into slices with each slice representing a single data category.
Pie
Each new chart is given a reference name viewed in the ________________box.
Reference
The individual parts of the chart are called chart _______________.
Elements
A ________________chart displays data values as columns with the height of each column based on the data value
column
A __________________column chart combines the data series values within a single column to show how much of the total is contributed by each item.
stacked
_____________charts are good for when you have lots of categories.
Pie
When a chart is selected, two chart _____________ tabs appear on the ribbon.
Contextual
Each element listed in the Chart Elements button contains a submenu of common ____________choices
formatting
A column chart turned on its side is called a __________chart
bar
A_______________stacked column chart makes the same comparison as the stacked column chart except that the stacked sections are expressed as percentages of the whole.
100%
The actual values that are plotted on the chart.
data series
When the chart is not ____________, the contextual tabs disappear.
Selected or active
Chart styles can be accessed either through the ________________button next to a selected chart
chart styles
It is better to use column and bar charts than pie charts when the number of categories is _______________.
large
In a pie chart, the size of each slice is ______________ to the quantity it represents.
proportional
After you select a data source, the_______________appears in the lower-right corner of the selection
Quick access tool
A chart is placed either within its own chart sheet or embedded within a _____________.
worksheet
By default, Excel applies the ___________colors to the pie chart slices and you cannot change them.
Theme
____________charts are plotted against a value axis displaying the values from the data series and a category axis displaying the category values associated with each data series.
column
_________________ charts display hierarchicial data that shouldbe compared as parts to the whole. It has different levels.
sunburst