Phil_b
09-06-2006, 02:42 AM
I have data set out in the below format:
Jan Feb Mar …
Stage A 4 5 2
Stage B 5 8 1
Stage C 3 6 4
Stage D 8 7 4
I am using this for a report and displaying it ‘as is’. I need the Stage’s to go vertically and the months to go horizontally (for space and presentation).
My problem now is that below I need a chart object showing the following data:
Jan Feb Mar …
Stage B 5 8 1
When I make the above into a line graph it puts the months in the legend rather than the stage.
I believe I need to transpose the data although I would rather do this at runtime rather than make temp tables etc. Does anyone have any suggestions on this?
I believe there is a TRANPOSE/ PIVOT SQL command although I have not been able to get it to work.
Jan Feb Mar …
Stage A 4 5 2
Stage B 5 8 1
Stage C 3 6 4
Stage D 8 7 4
I am using this for a report and displaying it ‘as is’. I need the Stage’s to go vertically and the months to go horizontally (for space and presentation).
My problem now is that below I need a chart object showing the following data:
Jan Feb Mar …
Stage B 5 8 1
When I make the above into a line graph it puts the months in the legend rather than the stage.
I believe I need to transpose the data although I would rather do this at runtime rather than make temp tables etc. Does anyone have any suggestions on this?
I believe there is a TRANPOSE/ PIVOT SQL command although I have not been able to get it to work.