title: Excel Pivot Series and Points
body: <p>I have a table:
  <a href="https://i.stack.imgur.com/R5xc4.png" rel="nofollow noreferrer">Source Table</a></p>
  <p>When I create a Pivot Chart (or Table), and drag/drop the month fields (ex. &quot;Oct-21&quot;) into Legend(Series) and Axis (Categories) (or rows or columns in the Pivot Table), Excel will automatically create the &quot;Month&quot; field from the table's selected columns, which I then use for parts of my Chart/Table.</p>
  <p>But for some reason, it's taking one of the numbers that's supposed to be in October, and classifying it as December.  If you look at the piece of data in the Chart (hover over the bar), it will say Series &quot;Sum of Oct-21&quot; Point <strong>&quot;Dec&quot;</strong> Value &quot;80000&quot;.  All the other data is fine, and I've even tried opening a new workbook, cut+copying over the data and recreating the Pivot Tables/Charts.</p>
  <p>How can I correct this misclassification?</p>