Page 7 of 17PREVNEXT

Charts III: Create a professional-looking chart

Combination chart with a column chart to represent actual sales and a line to chart to represent projected sales; and combination chart with formatting changes to the line chart and columns closer together

Fig. 1  A combination chart that needs help.
Fig. 2  A better-looking combination chart.

The chart in Figure 1 is a different kind of chart. It's a combination chart, which uses a column chart to represent the actual sales of Sir Rodney's Marmalade and a line chart to represent projected sales.

In Figure 2 the line chart was widened to make it stand out more. The color of the line was also changed to make it more visible. The marker style that indicates each month on the line chart was changed from a square to a circle, and the color for the marker was changed as well.

The columns were also changed. The distance between each column was decreased by increasing the width of the columns. That's adjusting the gap width, which you do by clicking a column and then right-clicking and selecting Format Data Series on the shortcut menu. Or you can select a column and click Selected Data Series on the Format menu. You'll learn the rest of the steps in the practice session, and you'll get to try out all of these changes.

To learn more about combination charts, see the online course Charts II: Choose the right chart type.

Page 7 of 17PREVNEXT