Need Chart or Graph that will go down the sheet instead of across

[liz5818]

Hello,
My data is basically meter marks on a pipe that can be pretty long. I would like the chart to be able to go down the sheet instead of across. This would mean that the vertical axis would actually be at the top going horizontally and the horizontal axis(which would contain the length of the pipe) would go down vertically with the data. The data points come from a separate worksheet. This worksheet gets data from a log which contains multiple sets of data, all which need to be graphed, but split up by certain items.
I want to attempt to do it this way due to it being somewhat easier to scroll through and I can't get the hang of adding a scroll bar to the graph. I am using a scatter plot to chart the data and basically the data goes in a straight line down the length of the pipe with data points at each meter mark. I have several graphs I need to do like this, and my current solution is breaking up the graphs and layering them underneath each other. Not sure if there is a solution to this or not.
Otherwise, help with adding a scroll bar to the graphs would also be a helpful solution as well.
Any clarification, please ask. I know this is a little rambled.
Thanks.

[judgeh59]

this may be too simplistic but if I understand this....if your chart looks like you want except the x and y are reversed....you can right click and go to select data...in that dialog box is a button - Switch axis or something along those lines....I'm not sure that will do exactly what you want without seeing your data set....HTH

[liz5818]

Thanks judgeh. I've attempted that, and it messes up how the graph/chart is laid out.