vba to switch columns to rows in a line chart

I have the following code:

Please Login or Register  to view this content.

The problem is that each series is in a row but it seems to think that the series data are in columns. I know that manually I can right click the chart, select "Select Data" and click on the "Switch Row/Column" button to fix it but I can't figure out how to do this in code. The macro recorder was no help as it only gave me this when I ran through the sequence manually.

Please Login or Register  to view this content.

Any help would be appreciated!

untested

Please Login or Register  to view this content.