title: Generate a multi-category axis label on al Chart
body: <p>I am trying to generate multi-category chart axis in excel with VBA. (see example picture below) </p>
  
  <p>My attempt at doing this with VBA, normaly i submit an array for my xvalues and this time I am trying to submit two arrays but I get type mismatch. Any ideas on how to pull this off?</p>
  
  <pre><code>With chart.SeriesCollection(1)
      .Name = "Data1"
      .Values = avgValue1
      .XValues = Array(columnVAlue, labelValue)
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/4VBVo.png" alt="Pick with multiple category axis"></p>
  
  <p><strong>* UPDATE *</strong></p>
  
  <p>I am using this chart from within Access so I cannot interface with a worksheet. </p>