Manipulating a two-axis graph.
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 |
Manipulating a two-axis graph.
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. |
Manipulating a two-axis graph.
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. |
Manipulating a two-axis graph.
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. |
Manipulating a two-axis graph.
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. |
All times are GMT +1. The time now is 04:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com