Hi,
I have data arranged in three columns which compare how 3 data sources differ in relation to each other. Hence value 1 means that, e.g., the data in column A is higher than whatever value in column B is. Value -1 means the value is lower in that column as compared to the value in the other column. The text "same" means the values compared are equal to each other.
How to plot the comparative values of the three columns on a chart so that the chart shows where the values overlap (or are equal to each other as represented by msg "same") and where they are higher or lower in comparison to other columns?
The sample data attached.
Thank you,
Gabriele
Bookmarks