title: How to change decimal on x-axis (i.e. scatter graph), using VBA?
body: <p>I was searching for how to change decimal, using VBA and I found the excellent answer below.</p>
  
  <p><a href="https://stackoverflow.com/a/32462504/9653254">https://stackoverflow.com/a/32462504/9653254</a></p>
  
  <p>However, for my graph, it is a scatter graph. So I need to change decimal on x-axis. Above code only change y-axis. Could you let me know how to change deciaml on x-axis?</p>
  
  <p>Thank you in advance.</p>
  
  <pre><code>Dim obj     As Object
  For Each obj In ActiveSheet.ChartObjects
     With obj.Chart.Axes(xlValue)
        .TickLabels.NumberFormat = "0.00"
     End With
  Next obj
  
  End Sub
  </code></pre>