Personally I would start by setting up a data page with columns for each "detail", so things like production number, make/model, date of production/inspection, fault type, fault location, full description etc.

Then think about what can be standardised in that list allowing you to use drop down lists for selection rather than free text (this is the bane of any number cruncher's life!) and draw up lists of possible values for each of these. Fault location could be one of those lists for example. If set up well in the first place these can be added too quite easily without need to amend formulas etc.

Next is thinking about what details the management want to see. The graphs you mention are one example, but occasionally a numeric table may be a more effective way of showing detail as not all things lend themselves well to graphs.

Once you have all that worked out you can build a "dashboard" so you can just keep adding details to the list and all the charts and tables will automatically update. You can have time scale selectors and other fancy things to restrict data and the ability to export certain parts and email it to management. That way your data capture can take less time than your current logbook requires and all the figures are ready all the time.

If that sounds like something you may be able to work with then I'm more than happy to help you with it.

BSB