different scales on same chart ...

[elizabeth]

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

 

[Richard Choate]

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

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

 

[Dan E]

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

 

[dvt]

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/Excel/Charts/ArbitraryGridlines.html).

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

Dave
dvt at psu dot edu

 

[Dan E]

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

Dan E