synch the scale of y axis1 and y axis2 dynamically

Arif shah

<p>Hi,</p><p> </p><p>Can someone please guide me how to synch the scales of y axis1 and y axis2. I have put revenue on y axis1 and on yaxis2 I have put an average line. Can someone please help me how to synch both the axis scale so that we can actually compare the average line to the revenue</p><p> </p><p>Regards</p><p>Arif</p>

GLO_FR

<p>Hi, </p><p> </p><p>in this case, you don't need 2 axis, but 2 series.</p><p> </p><p>Create a simple chart. On the second sheet, select your categorie and your first serie.</p><p>In the serie combo box, choose "Serie 2" and create the second serie.</p><p> </p><p>In the third sheet, select line serie for Serie 2.</p><p> </p><p>Example joined</p>