title: how to add horizontal axis labels to chart using macro
body: <p>i created a chart using the following macro:</p>
  
  <pre><code>ActiveSheet.Shapes.AddChart.Select
  ActiveChart.SetSourceData Source:=Range("'Sheet1'!$A$1:$A$13")
  ActiveChart.ChartType = xlLine
  </code></pre>
  
  <p>how to add horizontal axis label to the chart, because this code only adds my vertical columns.</p>
  
  <p>i need to input horizontal rows as well.</p>
  
  <p>I am Fairly new to macros, kindly help me out.</p>