Back to lesson
1. The chart shown below has a black line beside the vertical axis. If we wanted to get the orange and blue series lines to touch the black axis line, what would we need to do?
Right click the vertical ($) axis --> Format Axis --> Axis position --> On Tick Marks
Right click the horizontal (date) axis --> Format Axis --> Axis position --> On Tick Marks
Drag the lines closer to the axis
2. In the chart below the dates are standing vertically. What do we need to do to align them horizontally?
Select the dates then change their font size to something smaller.
Expand the chart width
Right click the dates --> Home --> Alignment --> Rotate Clockwise
3. In the chart below the orange line appears to be showing on top of the blue line. What would we do to get the blue line in front of the orange line?
Select the chart --> Design --> Select Data. Select the Boots series and click the “move down” arrow.
Select the blue line on the chart --> Chart Tools --> Format --> Bring Forward
Select the chart --> Design --> Select Data. Select the Shoes series and click the “move down” arrow.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement