Back to lesson
1. You have the following chart and you’d like to convert the Flexible Budget series to an area chart. What is the first thing you need to do?
Right click the Flexible Budget series and choose “Format Series”
Right click the Flexible Budget series and choose “Convert to Combination Chart”
Right click the Flexible Budget series and choose “Change Series Chart Type”
2. In the chart below, how many series of data are shown?
3: three lines series and background shading
3: two line series, and an area series
4: three lines series and an area series
3. Combination charts are not restricted to only area and line combinations. In looking at the chart below, how would you expect to build it?
Begin by plotting a dual series line chart, then selecting the orange series and changing the series chart type to a bar chart.
Start with a line chart and check the “combination” option.
Begin by plotting a clustered column chart, then change the blue series chart type to a line chart.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement