Hello! I need to create a run chart with phases. Each phase is defined by a change in a certain column. COL1 COL2 COL3 T=1, R02, P=2, T2=3, R03=5 0 5 T=1, R02, P=2, T2=3, R03=5 0 5 T=1, R02, P=2, T2=3, R03=5 0 5 T=1, R02, P=2, T2=3, R03=5 0 5 T=1, R02, P=2, T2=3, R03=5 0 5 T=1, R02, P=2, T2=2, R03=5 1 5 T=1, R02, P=2, T2=2, R03=5 1 5 T=1, R02, P=2, T2=2, R03=5 1 5 T=1, R02, P=2, T2=2, R03=5 1 5 T=5, R02, P=2, T2=2, R03=4 2 4 T=5, R02, P=2, T2=2, R03=4 2 4 T=5, R02, P=2, T2=2, R03=4 2 4 T=5, R02, P=2, T2=2, R03=4 2 4 T=5, R02, P=2, T2=2, R03=4 2 4 The text in the column is longer than this. In the run chart I don't want the full text, only the value that has changed (as in COL3). Or if that isn't possible perhaps just a counter (as COL2). The thing is that more than one value could have changed in COL1. The counter is shown in the second column. My question is - Can I make the chart with the changed values (as in COL3 and other columns like it) as phase labels in a run chart? - If not, How do I make the counter shown in COL2, which in Excel is easily done by referencing to its previous value (Col2(n)=Col2(n-1)+1). I have tried referencing the same column with a subscript, but it doesn't seem to work.
... View more