How would you do this with a secondary axis? My issue is I have 2 Y axes and
I want them both to adjust relative to each other based on the data. I know
I can manually change the maximum values, but I would rather change the value
in which the 2 axes relate and have the charts adjust accordingly.

For example, 6 on the primary axis will equal 1 on the secondary, 12 will be
2, and so on. If I need to adjust it to, say 5 and 1, how could I accomplish
that without manual chart adjustments?

Phillip

"Andy Pope" wrote:

Hi,

See Jon's information
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

Vince F wrote:
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info