title: PivotTable group skips ranges
body: <p>BACKGROUND: Excel pivot tables can group data into numerical ranges which you can then use as axis categories in a pivot chart.</p>
  
  <p>EXAMPLE: Excel might group a series of numbers from 1-30 into three groups:</p>
  
  <ul>
  <li>1-10</li>
  <li>11-20</li>
  <li>21-30</li>
  </ul>
  
  <p>But, if the data were only: 5, 6, 22, 29, then Excel would list <code>1-10</code> on the first row, and <code>21-30</code> on the second row of the pivot table.  It would skip the <code>11-20</code> range because there are no data values in that range.</p>
  
  <p>QUESTION: How can you include all groups, so when you create a pivot chart, it will be visually clear where the "holes" in the data are? (e.g., in the example above, if you were summing the data in each group, how could you get the pivot table to look like this:</p>
  
  <ul>
  <li>1-10:  11</li>
  <li>11-20:  0</li>
  <li>21-30: 51</li>
  </ul>
  
  <p>showing the middle group, even though there are no data values in that group?)</p>