Offset secondary axis

[Grayfox]

Hi all..

1. How do I move secondary axis so that it'll be displayed together
with the primary axis?

2. Is it possible to offset secondary axis so that it seems to be
continuing from primary axis?
the reason is because i'm plotting a value for 'H/D' which goes from 0
to infinity,.. but I'll break it at 'H/D'=5, and start with its
reciprocal 'D/H'..
so the H/D = 5 equals to D/H = 0.2 and
H/D = infinity equals to D/H = 0

pls kindly help... or any other suggestion...


Grayfox

 

[Jon Peltier]

Grayfox -

1. You can move the secondary Y axis near the X axis by double clicking
the secondary X axis, and on the Scale tab, setting the Y Axis Crosses
At to some appropriate value.

2. To get the kind of axis scaling/labeling you want, you could adapt
the Arbitrary Axis example on my web site:

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

I also have a reciprocal axis example:

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

- Jon

 

[Tushar Mehta]

You could plot the data on two charts, one going to H/D=0 to 5, the
other from D/H=0.2 to zero, then stack the two charts as in the
tutorial Excel | Tutorials | 'Stacked Charts' on my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions