TickLabelSpacing for months
<p>So I have a graph which has months on the x-axis. Currently VBA automatically steps through these months in steps of two. So, on the x-axis I see (for example): May-15, July-15, Sept-15, Nov-15... and so on. I want to see, May-15, Jun-15, July-15, Aug-15, Sept-15, Oct-15, Nov-15,...ie I want to change the x-axis to steps of one month. I have tried:</p>

<pre><code>      Charts("Chart 3").Axes(xlCategory).TickLabelSpacing = 1
</code></pre>

<p>But receive subscript out of range error?!
Please, any tips? Thank you so much in advance</p>