Microsoft Office Tutorials and References
In Depth Information
Creating a Combination Chart
As noted earlier, line charts are appropriate when the categories can be ordered
sequentially such as the Fund History line chart in which the categories represented
dates. In Figure 4-31, the sector categories do not have a sequential order and the lines
connecting the different categories have no meaning. You’ll remove these lines from the
chart to avoid confusing Ajita’s clients. Also, you’ll change the square markers to
horizontal line markers at each data point.
To remove the lines and edit the markers in the line chart:
1. Click the line for the S&P 500 data series to select it, if necessary.
2. Click the Chart Tools Layout tab on the Ribbon, and then click Format Selection
in the Current Selection group. The Format Data Series dialog box opens.
3. Click Line Color on the left side of the dialog box, and then click the No line
option button to remove the line from the line chart.
4. Click Marker Options on the left side of the dialog box, and then click the
Built-in option button. You can now select the type and size of the marker.
5. Click the Type arrow , and then click the horizontal line marker (the seventh
marker in the list).
6. Click the Size up arrow until 10 appears in the box. See Figure 4-32.
Marker Options in the Format Data Series dialog box
7. Click the Close button. The S&P 500 values appear only as data markers.