How to switch axis(graphs)?

neveax

New Member
Joined
Aug 2, 2005
Messages
6
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.

 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

RAM

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,670
Messages
5,573,569
Members
412,537
Latest member
Mohamed_5966
Top