Post reply

Create a graph with pre-existing tabular data...

  • September 25, 2013 at 10:36 am

    #278376

    I have a dataset generated in SQL Server that already returns tabular data. The columns are simply year, jan, feb, mar, ... with the data simply the number of units sold each month. I am having much more difficulty than I anticipated getting the correct line graph. I have tried multiple variations using the category and group settings in the chart data. If I take the data to Excel, I can get the result with no issues. A sample of the dataset being returned from SQL and the chart I am trying to create are shown below. Any help is greatly appreciated.

  • September 25, 2013 at 11:42 am

    #1653290

    It comes down to the data you have for the chart in SSRS to work on. Having the data in a denormalised format (jan, feb, mar etc) means that the chart does not have a single column that holds the value to represent. If the query was to be in a normalised format then the chart would be easy.

    Get the query output the data as shown below.

    Year | MonthName | MonthNumber | ValueToShow

    Create a chart and set the value as value to show and the category as MonthNumber. Add the year to the series. Change the category label to MonthName, this will order the x values by MonthNumber but show the MonthName.

    Fitz

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply