I have a reporting software that gives me a csv file with thousands of lines of data. I want to graph only the data that shows 80% or higher so now my data is down to couple hundred lines.
This is an example of the report and it’s format after filtering it down to the actual data I want…
07 30 2017 12:00:00 MPB0 0 MP 89.88537
07 30 2017 12:00:00 MPB0 1 MP 91.23927
07 30 2017 12:00:00 MPB0 2 MP 92.305
07 30 2017 12:00:00 MPB0 3 MP 92.78019
07 30 2017 12:00:00 MPB1 4 MP 91.78739
07 30 2017 12:00:00 MPB1 5 MP 92.25076
07 30 2017 12:00:00 MPB1 6 MP 93.66233
07 30 2017 12:00:00 MPB1 7 MP 92.35752
07 30 2017 12:00:00 MPB4 10 MP 83.53486
07 30 2017 12:00:00 MPB4 11 MP 84.30474
07 30 2017 12:00:00 MPB4 12 MP 84.55587
07 30 2017 12:00:00 MPB4 13 MP 85.994354
07 30 2017 12:00:00 MPB7 1C MP 92.72785
07 30 2017 12:00:00 MPB7 1D MP 93.2316
07 30 2017 12:00:00 MPB7 1E MP 93.3713
07 30 2017 12:00:00 MPB7 1F MP 94.269844
The data is collected every hour with 32 lines per collection
Using the reporting software I can tinker with the report but then I get this horrible line chart (because only data point of over 80% is shown).
I am trying to create a chart (preferably a scatter graph or something like that so there is no “ugly” connection lines) that will have data points from up to 32 data points and assign a color to each of the MPBXXX so that the data point can be correlated back to the MPBXX.
So in this chart I need...
1) a legend that will show which MPBXX belongs to which color in the chart (probably on either the right or left hand side of the chart).
2) The data and time of the data points (probably on the bottom of the chart)
3) The percentage from 80 thru 100 (on the other side from the legend)
any help or advise would be greatly appreciated!
Bookmarks