Controlling Line/Bar axis's

[Randall West]

When using Line/Bar charts, is there a way to contol the
series as to which one is used? If you have 4 or more
series, sometimes I'd like to only have one Y axis. Same
for using 6 or more series, the default is to divide the
series in half, but I'd like to controll what series goes
to either axis.

Thanks, Randy

 

[Jon Peltier]

Randy -

Those built-in custom types seem convenient at first, don't they.
Here's a better way, which takes a few more seconds, but gives you
complete control.

Make your chart with all the data showing up as one chart type (bar or
line, use the one which you'll use more in the finished chart), all on
the primary axis. Right click one that you want to change to another
type (line to bar, for instance), choose Chart Type from the popup menu,
and select the chart type for that series. Select the next one to
change and press F4 to repeat, and continue until you've switched all
you want to switch. Double click on a series you want to switch to the
secondary axis. On the Axis tab, select Secondary. Select the next one
to switch, and press F4, etc.

- Jon