X-Axis @ 0 wont work (PIC INCLUDED)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scrupul0us - 30 Sep 2004 05:35 GMT

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

Signature

scrupul0us

Reply to this Message

Jon Peltier - 30 Sep 2004 13:35 GMT

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/
_______

> 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
[quoted text clipped - 9 lines]
> minimum value for the left hand y-axis.. there has to be a real way
> todo it right... thanx guys

Reply to this Message