I have an excel spreadsheet that currently tracks fault reporting in our building. I am looking to do some form of trend analysis ideally to track the faults on the spreadsheet and then display them (by monthly totals so would also need to group them) in a multi line chart.

So for example at the bottom of the chart is date range by month, left column is fault totals, right column is type of fault.

I have attached a basic example of my spreadsheet

Example Chart

  • Is your data really that sparse, 2-5 faults per month? If so, with 5 or more fault types, it will be hard to do any meaningful analysis. – Bandersnatch Apr 19 '18 at 17:01
  • No apologies we actually usually have around 10-15 a month however i gave a quick example spreadsheet as the original contains sensitive information – R.DK500 Apr 20 '18 at 16:11

I would highly recommend looking into Pivot tables/charts. They are an easy, modular way to organize data and produce dynamic visualizations.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.