Dear experts,
I'm trying to create a correlation scatter-graph where each data-point belongs to a separate category.
My data is laid out in three columns like this:
A Category, B x-axis value, C y-axis value
I have no trouble creating a standard correlation scatter when I select column B and C, but then all data points are treated like one series, and my legend won't show the categories.
If I select columns A B and C and then graph, I get the categories correctly, but then the values in col B and C are shown like two separate series, not correlation.
Maybe a different data-layout would do the trick?
Regards from Oslo, Norway
I'm trying to create a correlation scatter-graph where each data-point belongs to a separate category.
My data is laid out in three columns like this:
A Category, B x-axis value, C y-axis value
I have no trouble creating a standard correlation scatter when I select column B and C, but then all data points are treated like one series, and my legend won't show the categories.
If I select columns A B and C and then graph, I get the categories correctly, but then the values in col B and C are shown like two separate series, not correlation.
Maybe a different data-layout would do the trick?
Regards from Oslo, Norway
