Microsoft Office Tutorials and References
In Depth Information
Showing Performance Against a Target Range
4. Select the entire chart feeder table and plot the data on a stacked column chart.
5. Right-click the Values series and choose Change Series Chart Type. Use the Change Chart Type
dialog box to change the Values series to a Line and to place it on the secondary axis (see
Figure 10-22). After confirming your change, the Values series will show on the chart as a line.
Figure 10-22: Use the Change Chart Type dialog box to change the Values series to a Line chart and
place it on the secondary axis.
6. Go back to your chart and delete the new vertical axis that was added; it’s the vertical axis to
the right of the chart.
7. Right-click the Lower Limit data series and choose Format Data Series.
8. In the Format Data Series dialog box, click the Fill icon. Choose the No Fill option under Fill
and the No Line option under Border (see Figure 10-23).
Figure 10-23: Format the Lower Limit series so that it’s hidden.
9. Right-click the Upper Limit series and select Format Data Series.
10. In the Format Series dialog box, adjust the Gap Width property to 0%.
That’s it. All that’s left to do is apply the minor adjustments to colors, labels, and other formatting.