Syncronise zero values

  • Thread starter Thread starter Brisbane Rob
  • Start date Start date
B

Brisbane Rob

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

Is this making sense to anyone?

Thanks for any hel
 
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
 
Back
Top