Hello,
I wanted to plot the data that I have from post #2 of my following thread:
where column D, that includes the "days" is the x axis.
I noticed that apparently scatter chart axes are not compatible with "text".
I know that I can use a "line" chart that takes both text and numbers for axis labels, but the problem with line chart is that the spacing between labels is uniform and does not reflect the actual value of the numbers.
So, is there any way to deal with this situation?
Thanks for any input!
I wanted to plot the data that I have from post #2 of my following thread:
How to make certain results appear at the beginning of SORT, followed by all other results?
Hello, I have some data for "drug_level", that I need to sort based on the day column, but I want the first two results to always correspond to the drug_level on the "screening" and "baseline" days, and then all other days sorted in increasing order. Also if there are more than one values for a...
www.mrexcel.com
where column D, that includes the "days" is the x axis.
I noticed that apparently scatter chart axes are not compatible with "text".
I know that I can use a "line" chart that takes both text and numbers for axis labels, but the problem with line chart is that the spacing between labels is uniform and does not reflect the actual value of the numbers.
So, is there any way to deal with this situation?
Thanks for any input!