How to create a 2 columns and 2 lines graph with non-related value
 

Hi,

I am trying to create a graph with 2 columns and 2 lines. I am able to get
the 2 colums ($000 value) and one line easily ($000 value), however the 4th
data series is completely out of range (it's a percentage value ranging
between 8 and 10%). I can see the line completely flat on the bottom axis but
would like to be able to move it up so it kind of "hangs over" the columns.

Any ideas that do not involve complexed programming?

Thanks,

How to create a 2 columns and 2 lines graph with non-related value
 

Double click on the line, and on the Axis tab of the Format Series dialog,
select Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chantal" wrote in message
...
Hi,

I am trying to create a graph with 2 columns and 2 lines. I am able to get
the 2 colums ($000 value) and one line easily ($000 value), however the
4th
data series is completely out of range (it's a percentage value ranging
between 8 and 10%). I can see the line completely flat on the bottom axis
but
would like to be able to move it up so it kind of "hangs over" the
columns.

Any ideas that do not involve complexed programming?

Thanks,