How to switch axis(graphs)?

[neveax]

How do I switch axis for the graph in the screenshot below? So that "Force(N)" is on the Y axis and "Elongation(cm)" is on the X axis?

Thanks.

 

[RAM]

Hi,

Select the chart, click on Chart in the menu and choose Source Data. In the Series tab click on the sheet symbol for Value and select the (Y) axis value as you would like to have it, then do the same for the (X) axis and OK.

Hope This Helps

RAM

 

[neveax]

it helped, thanks.

 

[RAM]

You are very welcome.

RAM