Dual-axis With Columns?

I have two data series that I wish to plot. One set
ranges from 1 to 6. The second set ranges from 40 to 75.
Using a single axis, obviously the 1 to 6 data are barely
visible. I want to keep both data sets plotted as columns
but I want to create dual axes. One axis from 0 to 10
would correspond to the values of 1 to 6. The second axis
from 0 to 100 would capture the data in the second set.

When I try to do this, I can create a mix of columns and
lines or columns and points but I can't keep both data
sets as columns. Someone who was trying to help me said
they got two axes with the data in columns but that it
stacked the columns. I can't even imagine that one but
thought I'd throw in the info in case it helps.

How do I graph two data sets of differing ranges, keep
both sets as columns and associate one set of columns with
one y axis and the second set of columns with an alternate
y axis?

See if this example helps:

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

dchem wrote:

I have two data series that I wish to plot. One set
ranges from 1 to 6. The second set ranges from 40 to 75.
Using a single axis, obviously the 1 to 6 data are barely
visible. I want to keep both data sets plotted as columns
but I want to create dual axes. One axis from 0 to 10
would correspond to the values of 1 to 6. The second axis
from 0 to 100 would capture the data in the second set.

When I try to do this, I can create a mix of columns and
lines or columns and points but I can't keep both data
sets as columns. Someone who was trying to help me said
they got two axes with the data in columns but that it
stacked the columns. I can't even imagine that one but
thought I'd throw in the info in case it helps.

How do I graph two data sets of differing ranges, keep
both sets as columns and associate one set of columns with
one y axis and the second set of columns with an alternate
y axis?