Scatter chart - data input

[Alwyn]

Good day,

I have found an excellent tool (or visualization) that will assist in data analysis, but are not at all sure how to start populating the raw data in Excel to display the info as per the chart below. I would appreciate any help or advice of how to start with the database.

The chart basically plots the emergency or reactive work order count versus the preventative maintenance (PM) work order count for each asset belonging to a specific type, such as steam turbines. The equipment shown in red has 100 PM’s in the two year period, but still experiences nine reactive or emergency work orders.Whereas, the equipment shown in yellow has no PMs or PdMs and has eight reactive work orders.

 

[Hui]

That looks like a simple scatter chart with 3 series
Can you post a sample file of data and explain why some data is red/yellow ?

 

[Alwyn]

Hi Hui, thank you for your time and assistance in this regard. I will upload a file with sample data shortly.
To explain the data in the graph and especially the red and yellow data point I will make use of an everyday example: Take your car for an example. Your car needs to be serviced at regular intervals at an approved dealership. All these events of the cars' services at the dealership is seen in the graph as all the PM / PdM data points.

Now between these service intervals your car breaks down, say for example a flat tyre. This event will count as a Reactive Work count seen on the graph. This is also events like a flat battery, failed indicator lamp etc.

If we look at the yellow data point, this will be a car that has never been to a dealership for its routine service, and had eight events where something failed on the car.

The red data point is a car that has been serviced at the dealership a lot of times, but also experienced a lot of other breakdowns and failures.

If you look at the very bottom of the graph, you will notice that there is a car that has been serviced a lot and never experienced a failure or breakdown.

Please let me know if this example was sufficient to answer your question regarding the yellow/red data points.

 

[Hui]

I understand the terms, it is how are they represented in the data that it is important

I will await the file

 

[Alwyn]

Hi Hui, thank you. I have uploaded the file with the raw data.

 

[Alwyn]

Just to come back to the red and yellow data points - both will be represented in the data as a PM03 order of which the yellow point has no PM01 orders, and the red point will have both PM01 and PM03 orders. In the data sample there will not be a yellow point event