X-Axis @ 0 wont work (PIC INCLUDED)

[scrupul0us]

I have a dual y-axis graph... one series has negative values and causes
the x-axis to move... ive tried using the "x-axis @ 0" but it doesnt
work

office XP

PIC:

http://www.ironchefbadass.com/www/chart.jpg

the only way i can get it to sort of look right is if i play with the
minimum value for the left hand y-axis.. there has to be a real way
todo it right... thanx guys

 

[Jon Peltier]

You want to do something like this:

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

Seems to me I'd want to plot Y=COLA vs. X=Salary in an XY Scatter chart. Otherwise,
any relationship between these two variables is very difficult to perceive.

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