Forum Discussion
Sorting defects based on the date they were found
TMan5757 You seem to have chosen a fairly complicated manner to summarise the data. If you re-structure the data a bit, perhaps standard pivot tables can do all of the grouping and sorting you need. Not exactly as in your example but with less effort and less chance for errors.
I have added an example to your file. The pivot table was customised a little bit to make it look "nicer". See if it could work for you.
TMan5757 The pivot table source can be made in such a way that it automatically expands when new data is added. If it can be put in what you call "the chart page" is difficult to judge. Not sure if you even would want to use that page, as it isn't really easy to maintain (at least, that how I think about it). My hope was that by showing you the pivot table, you would be triggered to rethink your approach to this report altogether.