title: Programmatically creating multilevel axis chart with VBA on Excel
body: <p>I have some code that retrieves data from a SAS Table on a server. I'm trying to chart this data using VBA, without copying it to an Worksheet first (Feeding the recordset directly into the charts)</p>
  
  <p>I've had success so far with this. The problem is, my charts need to have multilevel categorical X axis, and i'm having trouble automating this only with VBA</p>
  
  <p>What I'm trying to get is something like this</p>
  
  <p><a href="http://imgur.com/ElwHwjE" rel="nofollow">http://imgur.com/ElwHwjE</a> (I can't post the image due to lack of reputation)</p>
  
  <p>But so far all my attempts lead to this</p>
  
  <p><a href="http://imgur.com/id7Vua0" rel="nofollow">http://imgur.com/id7Vua0</a></p>
  
  <p>I know I can do this if I first make a Pivot Table from my recordset and then build a chart on top of it, but as stated before I'm trying to do this without copying the data into a Sheet.</p>
  
  <p>Also tried messing with TickLabel options (Multilevel and Depth), but so far to no avail.</p>