title: Secondary axis with the same number of steps as the primary axis?
body: <p>I am looking for a method to have the primary and secondary axes use the same number of steps (so that axis lines are always aligned on both axes).</p>
  
  <p>Currently, my primary axis has 5 steps and my secondary has 6 steps. I want both axes to have the same number of steps.</p>
  
  <p>Is this possible?</p>
  
  <p>The chartdata varies on the selection that is made in a validation list.
  The proces for this:</p>
  
  <p>On the dashboard, the user selects 5 options:</p>
  
  <ol>
  <li>retailer</li>
  <li>product</li>
  <li>fact 1</li>
  <li>fact 2</li>
  <li>fact 3</li>
  </ol>
  
  <p>fact 1 and fact 2 are on the primary axis; fact 3 is on the secondary axis.</p>
  
  <p>The values which correspond to the choices made under 1 - 5 vary a lot.
  So the values for the primary and secondary axes change a lot (at every new selection).</p>
  
  <p>For every new selection, code should calculate the new minimum and maximum values and the major unit for both axes in a way that the number of major grid lines is the same for both axes.</p>
  
  <p>I guess the above should be triggered by a worksheet_change event. But then I would wonder how I could set the major unit for both the primary and secondary axes.</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>I just found this site with vba code which should do what I am trying to do. I have not tried it yet, but I will. </p>
  
  <p><a href="http://www.myengineeringworld.net/2015/04/adjust-secondary-y-axis-scale-chart-vba.html" rel="nofollow">http://www.myengineeringworld.net/2015/04/adjust-secondary-y-axis-scale-chart-vba.html</a></p>