title: Crystal Reports month to month comparison chart over two years
body: <p>We are using Crystal Reports 2011 to generate a report with a number of charts. One chart in particular needs to display consumption (MBTU) for each month for over a two year span. We want to have similar months side by side so that it is easy to see the differences between the months. Here is a mockup showing what we want our chart to look like. The only difference is we want to show a full twelve months; Oct thru Sept.</p>
  
  <p><img src="https://i.stack.imgur.com/ePXwO.png" alt="Month to Month Consumption Comparison"></p>
  
  <p>Our data source is structured like so:</p>
  
  <pre><code>entity      'the entity we are summarizing
  consumption 'raw consumption in MBTU
  date        'this is a date field that includes month and year
  </code></pre>
  
  <p>However, we are unable to get our chart to display in this fashion. What we have accomplished is shown below.</p>
  
  <p><img src="https://i.stack.imgur.com/vLZdB.png" alt="enter image description here"></p>
  
  <p>We do not have data for beyond Sept 2012 which is why Oct,Nov,Dec 2012 is blank. However we do have data for Jan, Feb, Mar of 2011 but it is not displaying for some reason. Additionally, we want to the chart to start at Oct and run through Sep. </p>
  
  <p>Our parameters in the chart expert are set to:</p>
  
  <p>On Change of: @MonthName and @Year (in that order)
  Show Values: consumption</p>
  
  <p>Any thoughts as to how to acheive the effect we want within Crystal Reports?</p>