suitable graph to visualize shift wise ordinal data

Hi Anonymous ,

One question regarding you data does the several States by one days have a limit or can this be a big number of values?

Using the legend by state the chart has you refer groups the information together by the same states so not giving you the expected result.

One option I can see is to have a column that you make unique ID by status and sort number so that you can use in the leggend however with this option you would need to change all the colours of the datapoints by hand and if they are a lot it will hard work.