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.
Right click the data cell and choose “Add to Chart”.
Select the chart title and choose “Link to cell”.
2. How do you expand the width of the columns in a column chart (with one data series)?
Adjust the gap width.
Adjust the series overlap.
Select the column and drag the width indicator to expand it.
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 chart title.
The vertical axis, but only if data labels for the columns are added.
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 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).
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement