Forum Discussion
Charts using cells containing multiple values
Hi gurus, I run a spreadsheet for my organisation that tracks reasons for incomplete orders. In my spreadsheet I can allocate one of 5 reasons for any incompletions and these reasons are containe...
I hope I have explained this clearly and thanks very much for devoting some brain power to it!
What would be helpful, in addition to the verbal explanation, is a look at how your data actually appears on the spreadsheet. How it appears, how it's organized, can be a big factor in what method is most suitable--there are undoubtedly several methods that could be used.
Ideally, unless this is highly confidential data, you would help us help you by posting a copy of the actual workbook on OneDrive or GoogleDrive, with a link pasted here that grants access to it. If the data are confidential/proprietary, create a quick representation of the actual that uses a fictional set of data but still arrayed the same way.