Hi all,
In my research I am considering several source and sink temperature couples for analysis purpose, for instance -10,70 and -25, 90 and . . ., for each case, system efficiency is going to be determined. Here, I am trying to find a way in excel to show my temperature couples as X-axis but I can not figure it out.
Please let me know if you have any idea about my problem. Thanks, I think I need to use another drawing software, so if you know, let me know the name of it. thanks.
Regards
Reza
as u click on every axis it has an option as "format axis" it allows u to define the range :) wish u luck
Thanks Peyman,
My problem is sth else, my X-Axis values has no range, lets say, this X-Axis is gonna have 3 points, Hasan, Ali, and Abbas, there is no range, I am talking about this. I cannot figure it out how to make my X-Axis in a way with no mathematical order or range. Thanks
Reza
Hello Reza
i have solve a lot of this problem.
Can you show 4 rows and columns of your problem?
Hi Giorgio,
Thanks for your response,
I have attached the file (photo) instead of 1-2-3- .. for X Axis., I want to use -25,50 ; -25,70 ; -25,90 ; . . . correspondingly.
I would appreciate if you teach me how to do it, thanks.
Reza
Hi Reza
I have put your graph data in a Excel file ( i use OpenOffice.org)
The attached file contains a very simple solution to problem.
If you wish display particular axis data in a Graph , make a column with the data
then point it.
If it's near the solution then i'll happy to explain well it.
Best wishes
Giorgio
Hi Georgio,
I appreciate your response and time. Thanks
There is a problem, -25.5 is not correct for me, I need -25,5 . I tried to change . to , but it didnt work unfortunately.
Regards
Reza
Hello Reza
Change cell format from numeric to text, so you may put comma instead of decimal point. It's easier way, See attached file.
Alternative: change international setting of operative system, with a lot of side effects....
Regards
Giorgio
- Badges
- Science topic