combination column line on 2 axis question

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

The Chart Wizard allows you to plot two columns on the
primary x axis and a line on the secondary x axis. Does
anybody know how to add another column to the primary x
axis and keep the line on the secondary? In other words
three columns and 1 line.

Thanks!!!
 
Art -

It's easier to dispense with the "built-in custom" types (love that
oxymoron), and create your own. Make a chart with all of the series as
columns. Right click on the one you want to change, select Chart Type
from the pop up menu, and choose a Line type. Now double click on the
series, and on the Axis tab, select Secondary.

- Jon
 
Back
Top