Fixing primary and secondary axis
 

I have a set of data in a chart that on one axis shows percentage data and
the other axis the absoulte values, such as:
Primary Secondary
Period1 5% 100
Period2 -5% -20

How do I fix the axis so the 0 point is the same on both axis (without
manually working it out). This is a chart I want to copy for other data so
would be good to automate it now.

Thanks

Fixing primary and secondary axis
 

chriswilko wrote:
I have a set of data in a chart that on one axis shows percentage data and
the other axis the absoulte values, such as:
Primary Secondary
Period1 5% 100
Period2 -5% -20

How do I fix the axis so the 0 point is the same on both axis (without
manually working it out). This is a chart I want to copy for other data so
would be good to automate it now.

Thanks

Jon Peltier has a method for this on his site:

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

Fixing primary and secondary axis
 

Excel 2007
Pivot Table, Pivot Charts
Hybrid VBA/Formula solution.
No odd major tick spacing.
Grid lines line up.
http://www.mediafire.com/file/uexwgzthydz/02_03_09.xlsm