title: Set minimum value on chart axis using VBA
body: <p>Can you help me with this? I want to generate a minimum axis value for my chart based on a cell reference.</p>
  
  <p>Here is my code.</p>
  
  <pre><code>Private Sub Worksheet_calculate()
     With ActiveChart.Axes(xlValue)
         .MinimumScale = Worksheets("Chart Data").Range("E111").Value
     End With
  End Sub
  </code></pre>