excel: way to flip data axis?

[hahher]

is there easy way to reverse axis of data? so that instead of going from top to bottom, data goes from left to right?

 

[oog]

copy your data, and do a paste special. you can choose to transpose the data. i think that the paste region cannot overlap with the copy region.

 

[PowerEngineer]

If you click on the line tracing your data on the chart, you will see a "series" equation on the input line. The first entry inside the parentheses is the series name (that goes in the legend and is often absent), the second entry is the range of values for the X-axis, the third entry is the range of corresponding values for the Y-axis. You can flip the values on the X and Y axes by reversing the order of these last two entries. (If I understand what you're asking...)

 

[hahher]

Originally posted by: PowerEngineer
If you click on the line tracing your data on the chart, you will see a "series" equation on the input line. The first entry inside the parentheses is the series name (that goes in the legend and is often absent), the second entry is the range of values for the X-axis, the third entry is the range of corresponding values for the Y-axis. You can flip the values on the X and Y axes by reversing the order of these last two entries. (If I understand what you're asking...)

i mean flip the data on the spreadsheet itself, not in a chart.

 

[hahher]

Originally posted by: oog
copy your data, and do a paste special. you can choose to transpose the data. i think that the paste region cannot overlap with the copy region.

ahhh, thank you