title: Excel 2010 Chart axis not shown up
body: <p>I am converting a EXCEL 2003 application to EXCEL 2010.  Data are shown up fine but the axis does not show any more.  which function to show the axis with automatic scale?</p>
  
  <p>For Example: If you plot the following series in an Excel Line Chart. [0.22,0.33,0.44,0.55,0.66,0.77,0.88,0.99,1.1,1.21,1.32,1.43,1.54,1.65,1.76,1.87,1.98,2.09,2.2] Excel determines that the y-axis values should be [0,0.5,1,1.5,2,2.5] [<a href="https://stackoverflow.com/questions/1073819/how-does-excel-determine-the-axis-values-for-charts]">How does Excel determine the axis values for charts?</a><a href="https://stackoverflow.com/questions/1073819/how-does-excel-determine-the-axis-values-for-charts">1</a>. How to make the y-axis with the automatic values [0,0.5,1,1.5,2,2.5] shown in the chart?</p>
  
  <p>Thanks</p>
  
  <p>Updated with related codes -</p>
  
  <pre><code>With ActiveChart
           .SeriesCollection(2).Select
           '.SeriesCollection(2).AxisGroup = 2
  
           .HasTitle = True
           .ChartTitle.Text = OutputTitle &amp; Chr(10) &amp; ChartTitle2
           .Axes(xlValue).HasTitle = True
           .Axes(xlValue).AxisTitle.Text = AxisTitle1
           .Axes(xlValue).AxisTitle.Font.Bold = False
           .HasAxis(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlPrimary) = True
           .Export Filename:=ExportFile, FilterName:="GIF"
  End with
  </code></pre>
  
  <p>If I uncomment '.SeriesCollection(2).AxisGroup = 2, I will get the y axis to show but the x axis labels are messed up with mismatch with the Values. </p>
  
  <p>Current chart -
  <img src="https://i.stack.imgur.com/CelmH.png" alt="enter image description here"></p>
  
  <p>Desired chart with scaled axis shown -
  <img src="https://i.stack.imgur.com/bByVu.png" alt="enter image description here"></p>