I currently have two charts with different scales that i
would like to superimpose onto one another in order to
make one chart that compares both data sets. How can this
be done? Is it possible to create a single chart with
both data sets and then stretch a section of it (for
example: 1-10% on the y-axis is larger than 10-20%)?

thanks.
elizabeth

go to John Peltier's website with this link:
http://www.geocities.com/jonpeltier/Excel/index.html He has lots of great
info for combination charts and other stuff. If it is possible, he probably
has it. I only wish I could open the site myself. I apparently have some
faulty settings in my browser. Everybody else says it is working fine,
though, so you should have no problem.
Richard Choate

"elizabeth" <(E-Mail Removed)> wrote in message
news:0c2d01c34bba$966de2d0$(E-Mail Removed)...
I currently have two charts with different scales that i
would like to superimpose onto one another in order to
make one chart that compares both data sets. How can this
be done? Is it possible to create a single chart with
both data sets and then stretch a section of it (for
example: 1-10% on the y-axis is larger than 10-20%)?

thanks.
elizabeth

Elizabeth,

Though i'm not completely sure that this will accomplish what you need, you
can give the "Secondary Y-Axis" a try.
Right click the series (ie 10 to 20 %)
Choose "Format Data Series . . ."
Under the Axis tab set "Plot series on" to "Secondary Axis"

Dan E

"elizabeth" <(E-Mail Removed)> wrote in message
news:0c2d01c34bba$966de2d0$(E-Mail Removed)...
> I currently have two charts with different scales that i
> would like to superimpose onto one another in order to
> make one chart that compares both data sets. How can this
> be done? Is it possible to create a single chart with
> both data sets and then stretch a section of it (for
> example: 1-10% on the y-axis is larger than 10-20%)?
>
> thanks.
> elizabeth
>

elizabeth wrote:
> I currently have two charts with different scales that i
> would like to superimpose onto one another in order to
> make one chart that compares both data sets. How can this
> be done? Is it possible to create a single chart with
> both data sets and then stretch a section of it (for
> example: 1-10% on the y-axis is larger than 10-20%)?
>
> thanks.
> elizabeth

I can think of a couple of different alternatives.

One, as already suggested, is to use a secondary axis. Dan E gives
directions for that in his response.

Another option is a logarithmic y-axis. Then the 1-10% range will the same
size as the 10-100% range.

A third option might be the broken y axis. That is not a native feature of
Excel, but Tushar Mehta shows you how to do it at his web
site.(www.tushar-mehta.com, Broken Y Axis).

Finally, you might try arbitrary axis labeling as described on Jon Peltier's
site
(http://www.geocities.com/jonpeltier/...Gridlines.html).

You have lots of options. I hope you find one that you like.

Dave
dvt at psu dot edu

Hadn't thought of the log scale option, good call.

Dan E

"dvt" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> elizabeth wrote:
> > I currently have two charts with different scales that i
> > would like to superimpose onto one another in order to
> > make one chart that compares both data sets. How can this
> > be done? Is it possible to create a single chart with
> > both data sets and then stretch a section of it (for
> > example: 1-10% on the y-axis is larger than 10-20%)?
> >
> > thanks.
> > elizabeth
>
> I can think of a couple of different alternatives.
>
> One, as already suggested, is to use a secondary axis. Dan E gives
> directions for that in his response.
>
> Another option is a logarithmic y-axis. Then the 1-10% range will the
same
> size as the 10-100% range.
>
> A third option might be the broken y axis. That is not a native feature
of
> Excel, but Tushar Mehta shows you how to do it at his web
> site.(www.tushar-mehta.com, Broken Y Axis).
>
> Finally, you might try arbitrary axis labeling as described on Jon
Peltier's
> site
>
(http://www.geocities.com/jonpeltier/...Gridlines.html).
>
> You have lots of options. I hope you find one that you like.
>
> Dave
> dvt at psu dot edu
>
>