Author |
Topic |
|
ESSME
Germany
2 Posts |
Posted - 12/05/2023 : 3:09:04 PM
|
Dear Friends
i have a problem with drawing a plot. as you see in pic,the x-axis data are not in correct order,it begins with the the biggest number,and not finished with the smallest one, how can i fix it? i need it starts with the smallest one and finishes with the biggest one in x-axis.
thanks |
Edited by - ESSME on 12/05/2023 3:12:29 PM |
|
YimingChen
1613 Posts |
Posted - 12/05/2023 : 3:16:04 PM
|
It appears you have set Col(E) to be text. Please double click on the column header of Col(E), and in the dialog, set Format to Numeric.
Then to sort the values in Col(E), please highlight the column, then select menu Worksheet:Sort Columns:Ascending.
James |
|
|
ESSME
Germany
2 Posts |
Posted - 12/05/2023 : 4:34:45 PM
|
Thanks a lot James It works.
quote: Originally posted by YimingChen
It appears you have set Col(E) to be text. Please double click on the column header of Col(E), and in the dialog, set Format to Numeric.
Then to sort the values in Col(E), please highlight the column, then select menu Worksheet:Sort Columns:Ascending.
James
|
|
|
|
Topic |
|
|
|