I've generated two sets of biomechanical data for a medical research study
(one set is in Newtons, the other in Newton-meters). So, for each given
experimental model, I have two kinds of data. I'd like to put the results
from the two experiments side-by-side on the same bar graph. I figured out
how to create a two y-axis graph (with Newtons on the right and N-m on the
left), but when I added the second y-axis, Excel super-imposed the two bars
on top of one another. Is anyone aware of a means by which I can keep the
bars side-by-side? I must have spent a day trying to figure this out and
can't. It's as though I can either have two axises or I can have two
side-by-side bars, but not both.

Any help is most appreciated.

F Drake, MSIV University of Utah

On Tue, 2 Oct 2007, in microsoft.public.excel.charting,
FTD said:
I figured out how to create a two y-axis graph (with Newtons on the
right and N-m on the left), but when I added the second y-axis, Excel
super-imposed the two bars on top of one another. Is anyone aware of a
means by which I can keep the bars side-by-side?

See my response to Rockitman's recent question "Newbie needs a little
help on the value axis". He had the same problem (or was going to, as
soon as he followed my recommendation to use a second y-axis!) and the
solution is a pair of dummy bar series to keep the real bars from
overlapping.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Here's an illustrates tutorial:

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

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


"Del Cotter" wrote in message
...
On Tue, 2 Oct 2007, in microsoft.public.excel.charting,
FTD said:
I figured out how to create a two y-axis graph (with Newtons on the right
and N-m on the left), but when I added the second y-axis, Excel
super-imposed the two bars on top of one another. Is anyone aware of a
means by which I can keep the bars side-by-side?

See my response to Rockitman's recent question "Newbie needs a little help
on the value axis". He had the same problem (or was going to, as soon as
he followed my recommendation to use a second y-axis!) and the solution is
a pair of dummy bar series to keep the real bars from overlapping.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

Jon: sorry for the slow reply (hope you get this), but thanks for the help.

best wishes, FTD

"Jon Peltier" wrote:

Here's an illustrates tutorial:

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

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


"Del Cotter" wrote in message
...
On Tue, 2 Oct 2007, in microsoft.public.excel.charting,
FTD said:
I figured out how to create a two y-axis graph (with Newtons on the right
and N-m on the left), but when I added the second y-axis, Excel
super-imposed the two bars on top of one another. Is anyone aware of a
means by which I can keep the bars side-by-side?

See my response to Rockitman's recent question "Newbie needs a little help
on the value axis". He had the same problem (or was going to, as soon as
he followed my recommendation to use a second y-axis!) and the solution is
a pair of dummy bar series to keep the real bars from overlapping.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

Del, sorry for the slow reply (hope you get this), but thanks for the help.

best, FTD

"Del Cotter" wrote:

On Tue, 2 Oct 2007, in microsoft.public.excel.charting,
FTD said:
I figured out how to create a two y-axis graph (with Newtons on the
right and N-m on the left), but when I added the second y-axis, Excel
super-imposed the two bars on top of one another. Is anyone aware of a
means by which I can keep the bars side-by-side?

See my response to Rockitman's recent question "Newbie needs a little
help on the value axis". He had the same problem (or was going to, as
soon as he followed my recommendation to use a second y-axis!) and the
solution is a pair of dummy bar series to keep the real bars from
overlapping.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.