Hui, thank you very much for your amended file. Now I questioning the logic I had in the original file. The columns represent parts of a management system, like Plan-Do-Check-Act, and the rows represent types of problems that might be causes of an upset condition. I am trying to determine how to organize the data coming out of a database to be able to visualize it to identify trends. The bubble chart is one option under consideration.
At current thinking, each upset condition report would select one or more codes (column D) and then relate it to one or more sections of the management systems. That is what I tried to show in the chart. However, the far left is more like a reference chart layout where the primary cause is listed (the whole numbers) and then finer grain reasons are 1.1 and have potential to go another layer deeper at 1.1.1.
The commercial database people have told us to do a report and chart is very expensive to program and I really want to find a simpler way to get everything we want. Exporting the data to spreadsheet, then doing macro there is what is under consideration. Do you have the time and energy to explain what kind of logic it would take to be able to see trends of the "causes" as tied back to the management system? There is a guy on our team who can program macros if I can get the logic to him. Our team is meeting next week like a bootcamp, so any other suggestions are welcome for how to organize the export and visual the data. Thank you a million times over for responding to my request for help. You give me hope.
