title: Powerpoint Chart: Query on xlValue and xlCategory of Axis class
body: <p>In PPT charts, under the <strong>xlAxisType</strong> class there are three members. <em><strong>xlCategory</strong></em> is one such member and <strong>xlValue</strong> is another member. There is a collection named <em><strong>CategoryNames</strong></em> of the Axes class which I can make use for the type <strong>xlCategory</strong> but not for <strong>xlValues</strong>.</p>
  <p>I would like to know which members of axis class can i make use of for the type <em><strong>xlValue</strong></em> . Intellisense is also not working for my case. [Please see pic for clarity &amp; code below].</p>
  <p><em>Note: I have switched on the Show Hidden Member in the Object Browser</em></p>
  <pre><code>   'Code snippet
     If ThisShape.HasChart = True Then
          
          Dim ThisChart As Chart
          Set ThisChart = ThisShape.Chart
  
          arr = ThisChart.Axes(xlCategory).CategoryNames
          MsgBox UBound(arr)
    
          Dim CategoryList As Variant
          CategoryList = ThisChart.Axes(xlValue).CategoryNames
          MsgBox UBound(CategoryList)
  
     
  </code></pre>
  <p><a href="https://i.stack.imgur.com/ICn8H.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ICn8H.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/0Y6Ci.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0Y6Ci.png" alt="enter image description here" /></a></p>