Back to lesson
1. Which method can be used to link a chart title to data?
Select the chart title, press = and then select the cell.
Select the chart title and choose “Link to cell”.
Right click the data cell and choose “Add to Chart”.
2. How do you expand the width of the columns in a column chart (with one data series)?
Adjust the series overlap.
Select the column and drag the width indicator to expand it.
Adjust the gap width.
3. Imagine that you have a single-series column chart implemented in Excel by default. Which elements in the chart can be removed to make the chart more effective in terms of its power to communicate?
The vertical axis, but only if data labels for the columns are added.
The chart title.
The horizontal gridlines.
4. What is the main reason for removing elements from a chart, such as superfluous labels and gridlines?
To remove distractions and allow readers to focus on the main messages communicated by the chart.
To make the chart look more glamorous (flashy and glitzy).
To save on printer costs, such as ink.
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement