Back to lesson
1. Which method can be used to link a chart title to data?
Select the chart title and choose “Link to cell”.
Select the chart title, press = and then select the 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 gap width.
Select the column and drag the width indicator to expand it.
Adjust the series overlap.
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 save on printer costs, such as ink.
To make the chart look more glamorous (flashy and glitzy).
To remove distractions and allow readers to focus on the main messages communicated by the chart.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement