O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Combination (Overlay) Charts

Sometimes you'll find that a chart with multiple data series becomes more intelligible if you plot one or more series in a style that contrasts with the other series. For example, you might want to plot one series as columns and another as a line. To create this kind of overlay chart, first see if the combination you're looking for is already represented on the Custom Types tab of the Chart Wizard's Step 1 dialog box. If it's not, follow these steps

  1. Create the chart using one of the standard chart types.

  2. On the finished chart, right-click the data series that you want to appear in a contrasting style.

  3. From the shortcut menu, choose Chart Type.

  4. Select the style you want, and select the Apply To Selection check ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required