CH 3: Charts
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| 100% stacked column chart | show 🗑
|
||||
| show | A chart type that emphasizes magnitude of changes over time by filling in the space between lines with a color.
🗑
|
||||
| Axis | show 🗑
|
||||
| show | A label that describes either the category axis or the value axis. Provides clarity, particularly in describing the value axis.
🗑
|
||||
| show | A chart type that compares values across categories using horizontal bars. In a bar chart, the horizontal axis displays values and the vertical axis displays categories.
🗑
|
||||
| show | A chart type that shows relationships among three values by using bubbles to show a third dimension. The third dimension is indicated by the size of the bubble; the larger the bubble, the larger the value.
🗑
|
||||
| Category axis | show 🗑
|
||||
| Category label | show 🗑
|
||||
| show | A visual representation of numerical data and helps reveal trends or patterns to help people make informed decisions.
🗑
|
||||
| Chart area | show 🗑
|
||||
| show | A component of a chart that helps complete or clarify the chart.
🗑
|
||||
| Chart filter | show 🗑
|
||||
| show | A sheet within a workbook that contains a single chart and no spreadsheet data.
🗑
|
||||
| Chart style | show 🗑
|
||||
| Chart title | show 🗑
|
||||
| Clustered column chart | show 🗑
|
||||
| show | A type of chart that displays data vertically in columns to compare values across different categories.
🗑
|
||||
| Combo chart | show 🗑
|
||||
| Combo chart | show 🗑
|
||||
| Data label | show 🗑
|
||||
| Data point | show 🗑
|
||||
| Data series | show 🗑
|
||||
| Data table | show 🗑
|
||||
| show | A chart type that displays values values as percentages of the whole but may contain more than one data series.
🗑
|
||||
| Error bar | show 🗑
|
||||
| show | A chart type in which one or more pie slices are separated from the rest of the pie chart for emphasis.
🗑
|
||||
| show | A horizontal or vertical line that extends from the horizontal or vertical axis through the plot area to guide the reader's eyes across the chart to identify values.
🗑
|
||||
| show | A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series in a chart.
🗑
|
||||
| show | A chart type that displays lines connecting data points to show trends over equal time periods, such as months, quarters, years, or decades.
🗑
|
||||
| Pie chart | show 🗑
|
||||
| show | The region of a chart containing the graphical representation of the values in the data series.
🗑
|
||||
| Radar chart | show 🗑
|
||||
| Sizing handles | show 🗑
|
||||
| show | A small line, column, or win/loss chart contained in a single cell to provide a simple visual illustrating one data series.
🗑
|
||||
| show | A chart type that places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.
🗑
|
||||
| show | A chart type that shows fluctuations in stock changes, such as the high, low, and closing stock prices for a given company on a given day.
🗑
|
||||
| Surface chart | show 🗑
|
||||
| Trendline | show 🗑
|
||||
| show | The chart element that displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart.
🗑
|
||||
| show | A chart type that shows a relationship between two variables using their X and Y coordinates. Excel plots one coordinate on the horizontal X-axis and the other variable on the vertical Y-axis. Used in educational, scientific, and medical experiments.
🗑
|
||||
| X-axis | show 🗑
|
||||
| show | A vertical border that provides a frame of reference for measuring data vertically on a chart.
🗑
|
||||
| show | Pie chart
🗑
|
||||
| show | Select the data source, select the chart type, and then size and position the chart.
🗑
|
||||
| show | Single-cell chart
🗑
|
||||
| If you want to show exact values for a data series in a bar chart, which chart element should you display? | show 🗑
|
||||
| The value axis currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100? | show 🗑
|
||||
| You want to create a single chart that shows each of five divisions' proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs? | show 🗑
|
||||
| Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend? | show 🗑
|
||||
| show | Design
🗑
|
||||
| show | Chart Quick Analysis.
🗑
|
||||
| show | A rectangle with a white fill color.
🗑
|
||||
| show | Clustered column chart
🗑
|
||||
| Miniature chart contained in a single cell. | show 🗑
|
||||
| show | Line chart
🗑
|
||||
| show | Chart title
🗑
|
||||
| Label that describes either the category axis or the value axis. | show 🗑
|
||||
| show | Legend
🗑
|
||||
| Chart type that compares categories of data horizontally. | show 🗑
|
||||
| Chart that shows each data point in proportion to the whole data series. | show 🗑
|
||||
| show | Data point
🗑
|
||||
| show | Stock chart
🗑
|
||||
| show | Sizing handle
🗑
|
||||
| show | Gridline
🗑
|
||||
| show | X Y (scatter) chart
🗑
|
||||
| show | Data series
🗑
|
||||
| show | Task pane
🗑
|
||||
| Provides descriptive group names for subdividing a data series. | show 🗑
|
||||
| show | Plot area
🗑
|
||||
| Boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels. | show 🗑
|
||||
| Descriptive label that shows the exact value of the data points on the value axis. | show 🗑
|
||||
| show | Value axis
🗑
|
||||
| show | compares values for one set of data.
🗑
|
||||
| show | compares two or more sets of data in one chart
🗑
|
||||
| 3-D chart | show 🗑
|
||||
| show | a line used to depict trends and forecast future data.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
TroyIS2241
Popular Computers sets