0

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

Improve this question
2
  • 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
    Commented Apr 19, 2018 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
    Commented Apr 20, 2018 at 16:11

1 Answer 1

Reset to default
1

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

https://support.office.com/en-us/article/create-a-pivotchart-c1b1e057-6990-4c38-b52b-8255538e7b1c

Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .