Data to Chart Problem

[Phil_b]

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.

 

[Phil_b]

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.

hi guys any help with this or suggested area to focus my attention?