Manipulating a two-axis graph.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FTD - 03 Oct 2007 04:09 GMT

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

Reply to this Message

Del Cotter - 03 Oct 2007 09:54 GMT

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

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

Jon Peltier - 03 Oct 2007 12:49 GMT

Here's an illustrates tutorial:

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

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

>>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
[quoted text clipped - 5 lines]
> 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.

Reply to this Message

FTD - 12 Oct 2007 23:45 GMT

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

best wishes, FTD

> Here's an illustrates tutorial:
>
[quoted text clipped - 16 lines]
> > 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.

Reply to this Message

FTD - 12 Oct 2007 23:46 GMT

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

best, FTD

> >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
[quoted text clipped - 6 lines]
> solution is a pair of dummy bar series to keep the real bars from
> overlapping.

Reply to this Message