title: Creating a Year Over Year Line Graph Based on Pivot Table
body: <p>I am trying to compare Year over Year revenue for October on a line graph and I have decided my best approach is to create a pivot table with my month column grouped by a month and year format. My value is the sum of revenue. I then clicked on the pivot table and created a line graph that creates a total for all of my data I then filtered my row label "months" for only october and modify my graph data to create two series (2013 &amp; 2014) and modify the Y value to be the revenue value, name to be the year and x axis label to be October, but no data appears on the graph. Why is this happening and what is the best fix?</p>
  
  <p><img src="https://i.stack.imgur.com/xmait.png" alt="2013 chart range"></p>
  
  <p><img src="https://i.stack.imgur.com/7o3Jb.png" alt="2014 chart range"></p>