Hi, I usually can select a column of data, then create a scatter plot from that data with each value being plotted on the y-axis (and the x-axis corresponding to each point's row).
However, when I try this now, it is not working. If the column has a header, it just puts EVERY value into the title? Why?!
If I do this without a column header, it does something even more bizarre- it plots the first point as it should, but each subsequent point is plotted as (row, 0)!
I've attached images for both use cases. I've tried formatting the cells to both "general" and "number." Same result.
Why did this stop working in Excel???
Latest version of x64 office 365, Windows 10.
However, when I try this now, it is not working. If the column has a header, it just puts EVERY value into the title? Why?!
If I do this without a column header, it does something even more bizarre- it plots the first point as it should, but each subsequent point is plotted as (row, 0)!
I've attached images for both use cases. I've tried formatting the cells to both "general" and "number." Same result.
Why did this stop working in Excel???
Latest version of x64 office 365, Windows 10.