I cannot figure out how to chart some data. I have attached a spreadsheet with three columns of data: Control ID, Test ID and Workstream.
I am trying to show that for any one Control ID, there may be more than one Test ID and more than one Workstream associated with the test Id.
For the life of me I can't get the data to chart properly. I don't care which type of chart is used. I just want to illustrate the above. If someone could show me how to present the information in chart form - perhaps two different views - I would greatly appreciate it.
See attached spreadsheet.