Microsoft Office Tutorials and References
In Depth Information
Changing the chart type
Plotting the Average series as a line instead of a column improves the readability of the
chart, allowing you to see at a glance who is and isn’t above average:
With some data sets, Excel will recognize that a combo chart is appropriate and will
propose it in the Recommended Charts gallery. If that doesn’t happen, however, you can
always change a single-type chart to a combo at any time. Select the chart, click Change
Chart Type, and then choose Combo in the list of chart types at the left side of the dialog
box. Select one of the chart pictures at the top of the dialog box, above the preview
window, and then work with the options in the bottom of the dialog box to get the
combination of types that you want. In the following dialog box, for example, you can see that Excel
has correctly intuited that the Average series should be a line, but it has incorrectly
proposed to plot Herbinger as a line as well.
Search JabSto ::

Custom Search