Chart from pivot data

• shaun-233951

  Grasshopper

  Points: 16

  More actions

  January 31, 2011 at 4:53 am

  #230924

  I have a set of pivot data that I am trying to plot in a stacked bar chart in SSRS 2008.

  My data looks something like this:

  Period 1 Period 2 Period 3 Type

  11 16 10 A

  56 18 29 B

  I want to create a stacked bar chart for this data, so the X Axis would be the different periods and the stacked bar would be formed from the two values given by A and B.

  Can anyone help?

  Please refer to the screenshot for an idea of what I am doing wrong.

• Doug Lane

  SSCrazy

  Points: 2118

  More actions

  January 31, 2011 at 8:06 am

  #1280441

  Have you tried setting the process type as a category field? If that doesn't work, you might have to unpivot in order to get the time series in rows.