How to plot where values differ and where they converge?

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

Hi,

Having no problem to to replace 'same' with '0', I cannot figure out how to convert text into numbers in one go. Checked help, and all I can do is to go one cell by cell...

The other problem, even with a little sample of data stored as numbers, I get strange line charts, which is what I basically would love to get. On the line chart, I expected to get 3 different lines corresponding to the sequence of data in each column. I also expect that the lines converge if the adjacent cells in each column (e.g. A4, B4, C4)share the same number value (e.g. 0,0,0 or 1,1,1). None of this happens. All I get is a bizzare result as this:

A>B A>C B>C
1 1 -1
-1 -1 0
-1 1 1
-1 1 1
-1 -1 1
-1 1 1


result.JPG