topic Use column name as a value for X axis in Discussions

Use column name as a value for X axis

ruskicar — Sat, 10 Jun 2023 23:33:44 GMT

Hi,

can I use a value in column name as an X value to fit Y by X?

I have 10 columns with multiple rows, and for all rows the X is the same (i.e. the value in the column name).

Thanks.

Re: Use column name as a value for X axis

txnelson — Mon, 12 Jul 2021 12:21:46 GMT

I am not sure if I am understanding exactly what your data structure looks like, but if my interpretation is correct, the short answer is that you can not use the column header as a value. However, I am sure there is a way to make that work. It would really be helpful if you could provide a sample of your data,?

Re: Use column name as a value for X axis

ruskicar — Mon, 12 Jul 2021 13:31:51 GMT

Hi,

this is a screenshot of a sample of data structure.

For each row, the Y values are given in cells, while the X values should be the value of the column name (0.5, 1, 2, 4, ...) . I would like to use these X values to do Fit Y by X analysis, and to also plot a scatter plot where each row is different colour.

Thanks.

Re: Use column name as a value for X axis

ruskicar — Mon, 12 Jul 2021 13:27:57 GMT

Hi,

I just discovered a simple solution: if I simply transpose the final table, the first column is the value of the column labels, and other columns are value of rows. Then it is easy to do Fit Y by X and to plot a scatter plot.

All the best.

Re: Use column name as a value for X axis

txnelson — Mon, 12 Jul 2021 13:30:17 GMT

You can also just stack all of the columns, and then you can do your fit y by x