title: SSRS Charts Query and Data Series
body: <p>I'm new to this forum but Id like to ask about Charting in Reporting Services which I am completley new to too. </p>
  
  <p>I want to create a chart data series that is called Months displaying the data April to March. However, the data in the tables and query is set us as follows not having a <code>monthname</code>; returns data fields; <code>Ref, Year, Month1datavalue, Month2datavalue, Month3datavalue.... Month12datavalue</code>.</p>
  
  <p>Query as below:</p>
  
  <pre><code>SELECT     ChartData.Year, ChartData.Month1, ChartData.Month2, ChartData.Month3, ChartData.Month4, ChartData.Month5, ChartData.Month6, ChartData.Month7, 
                        ChartData.Month8, ChartData.Month9, ChartData.Month11, ChartData.Month10, ChartData.Month12, ChartData.SeriesName, ChartData.ColorName, ChartData.Style, 
                        Performance.ReferenceNo, Performance.ShortName, Performance.FullName, Performance.Description, Performance.Active, Performance.Deleted
  FROM         ChartData INNER JOIN
                        Performance ON ChartData.PerformanceID = Performance.PerformanceID
  WHERE     (ChartData.Year = 2015)
  </code></pre>
  
  <p>I create the chart but the <code>month1data</code> appears as a separate series to <code>month2data</code>. Ideally I would like the <code>month1data,month2data,month3data</code> fields to be as one series being able to show the month names in the horizontal axis title.</p>
  
  <p>Any ideas for such as novice?</p>
  
  <p>Thanks</p>