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...sOnTwoAxes.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?
>
>