Manipulating a two-axis graph.

[Guest]

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

 

[Del Cotter]

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.

 

[Jon Peltier]

Here's an illustrates tutorial:

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

- Jon

 

[Guest]

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

best wishes, FTD

 

[Guest]

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

best, FTD