Syncronise zero values
 

I have seven columns of data to chart. Columns A & B have values around
500,000 to 600,000 and I wish to show them against the right hand axes
as a line chart. The remaining columns have values from -50,000 to
+200,000 and I wish to show them against the left hand axes as column
chart. Is it possible to get their zero values on the same level?

Is this making sense to anyone?

Thanks for any help


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=550743

Syncronise zero values
 

You need to solve this simple algebraic equation.

Y1positive/Y1negative=Y2positive/Y2negative

where
Y1positive is the max. value on the y axis on the left
Y1negative is the min. value on the y axis on the left
Y2positive is the max. value on the y axis on the right
Y2negative is the min. value on the y axis on the right

You can specify 3 values and that determines the fourth. For example,
if you decide Y1positive=600,000, Y2positive=250,000, and Y2negative=
-100,000 then, Y1negative is given by 600000/250000*(-100000) = -240,000

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...

I have seven columns of data to chart. Columns A & B have values around
500,000 to 600,000 and I wish to show them against the right hand axes
as a line chart. The remaining columns have values from -50,000 to
+200,000 and I wish to show them against the left hand axes as column
chart. Is it possible to get their zero values on the same level?

Is this making sense to anyone?

Thanks for any help


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=550743

Syncronise zero values
 

Thanks very much - you'd think that Bill could code that in quite
easily...!


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=550743