Half dozen of the other. I've been very successful with the dummy axis
approach. I will define a range pseudo-secondary Y axis values calculated by
formulas similar to those I use to determine optimum axis scale parameters
(min/max/major). I define more than I need, say 20 labels for an axis which
I think will use 12 or 15 labels, and the formulas return #N/A if they are
not needed. I temporarily put non-#N/A values in the 20 cells while I apply
20 labels (cell links, actually) to the 20 data points; Excel remembers the
data label links as long as they were defined one time. This becomes a
dynamic, self-contained, non-VBA approach to this issue. Obviously a full
discussion is light-years beyond a newsgroup thread, but I have gotten to
the point where I can set up one of these axes in 15 minutes, then forget
it.

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


"Tushar Mehta" wrote in message
om...
Jon,

Each approach has its limitations. After all, each is working around
limitations in XL and nothing will be as good as having XL do the needful.
In the case of the dummy axis, the 3rd column labels don't update as the
data range expands. I've been burnt by *that* on more than one occasion.
In the case of using a secondary axis, it does need realignment. So, six of
one...

--
Regards,

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

In article ,
says...
Unfortunately this requires a bit more maintenance. The two vertical axes
must be aligned, then kept in alignment if the data changes, whereas the
dummy axis can be made with points covering a broader range than at first
needed, and points outside the range will not appear. Also you are forced
(in most cases) to use irregular min or max to make it work (e.g., 32 and
92°F) instead of natural multiples of 5 or 10.

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


"Tushar Mehta" wrote in message
om...
I know Jon has already given you the steps to align two axis but a worked
out example using Centigrade and Farenheit is at

Single Chart Dual Axis
http://www.tushar-mehta.com/excel/ch...0graph%20dual%
20axis.htm

As far as the other issue goes, you can use color and text to indicate
which
series goes with which chart. For example, if you have only one series
on
each axis, simply color the axis and the corresponding series the same
color. If you have multiple series on each axis, add a textbox that
tells
the reader which series goes on which axis.

--
Regards,

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

In article ,
says...
i am trying to chart 2 different sets of data:

1. average temperature for various cities in both celsius and
fahrenheit.
PROBLEM: if i have celsius on the primary x axis and the fahrenheit on
a
secondary x axis it gives me 2 columns. i want one column per city
which
will
give me the temp in celsius on the primary x axis and the corresponding
fahrenheit temperature on secondary y axis (conversion of celsius to
fahrenheit done with formula of celsius temp*9/5+32). can this be done?

2. i am charting rainfall in 5 cities over 12 months but the data range
is
very wide. one of the cities has 10x more rain than 3 of the other
cities.
this makes it almost impossible to read the chart. if i plot that city
on
a
secondary axis, when someone else looks at my chart, how can they know
what
city corresponds to primary x axis values and what corresponds to
secondary x
axis values? it is very confusing.

fern