Looking for some advice on a charting requirement.
Items can be stored on racks that are varying sizes; different rows, columns and a depth of either 1 or 2 units. I've built a system where the user can input the number of rows, columns and a depth and then a table of storage locations is created.
Once inventory has been assigned to a location on a rack, the client wants to be able to visually see what is in each slot - is it empty or occupied and if occupied what's in it (maybe a tooltip to display the item name).
As described to me, a scatter graph that is rows vs columns vs depth is desired. Or a visual cross tab report. Given that a rack can be variable in size - probably up to 20 x 10 x 2, creating a fixed cross tab layout is less desirable.