combination column line on 2 axis question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Art - 15 Dec 2003 16:09 GMT

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!!!

Reply to this Message

Jon Peltier - 15 Dec 2003 16:59 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> The Chart Wizard allows you to plot two columns on the
> primary x axis and a line on the secondary x axis. Does
[quoted text clipped - 3 lines]
>
> Thanks!!!

Reply to this Message

Art - 15 Dec 2003 18:42 GMT

Thanks Jon, that works really well and it was easy to do
thanks to your clear explanation!

>-----Original Message-----
>Art -
[quoted text clipped - 20 lines]
>
>.

Reply to this Message