+ Reply to Thread
Results 1 to 9 of 9

Need help developing a chart for numerous data points at the same time

  1. #1
    Registered User
    Join Date
    07-31-2017
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    4

    Need help developing a chart for numerous data points at the same time

    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!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need help developing a chart for numerous data points at the same time

    Does the attached give you a starter for 10?

    If you want different colours for the points then you'll probably need vba - unless Andy P can think of some other solution.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need help developing a chart for numerous data points at the same time

    ...and here's one macro that will colour the points for the #2 post
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-31-2017
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    4

    Re: Need help developing a chart for numerous data points at the same time

    unfortunately that wouldn't work. I should have included a longer list in my example. So in your sheet it spreads the data point out. I need all of the 12:00 data points in one "column" and then the next "Column" would be the data points from 1:00. So if you took the data points on the chart you created and stood them on end so that you have 10 data points going up the 78-96% (Y axis) for a single 12:00 entry on the (X axis) and then the MPB00 would be blue, MPB01 would be yellow, MPB02 would be red, etc...
    uhg.jpg

    This is what I can get in my reporting software. If I could just remove all the connecting lines and show the data points only it would be perfect

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Need help developing a chart for numerous data points at the same time

    Would a pivot chart suffice?

    You would need to format the series to have a marker and no line
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need help developing a chart for numerous data points at the same time

    Just a long shot thought but does your software allow you to set the colour of the lines independent of the point markers? If so you could set the line colour to white.

  7. #7
    Registered User
    Join Date
    07-31-2017
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    4

    Re: Need help developing a chart for numerous data points at the same time

    unfortunately I can't control the colors used

  8. #8
    Registered User
    Join Date
    07-31-2017
    Location
    Ohio
    MS-Off Ver
    2016
    Posts
    4

    Re: Need help developing a chart for numerous data points at the same time

    I was afraid it would be a pivot chart. That's a chart type I have no experience with. Always good to learn new things

    Thanks for pointing me in the right direction!

  9. #9
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Need help developing a chart for numerous data points at the same time

    Pivot charts are the same as normal charts.

    They are restricted to a sub set of the charts as types like xy-scatter are not supported.
    The data source for the chart is also restricted to the pivot table.

    But things like formatting are just the same.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to chart multiple data points on a single chart?
    By stang3O2 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-12-2017, 02:06 PM
  2. Combining numerous dates into 12 median points
    By ablackburn21 in forum Excel General
    Replies: 3
    Last Post: 03-04-2016, 04:58 PM
  3. [SOLVED] Drag & Drop Chart Series Points At Run Time (Help Needed From Excel VBA Gurus)
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-08-2015, 07:08 AM
  4. Replies: 6
    Last Post: 11-10-2014, 12:39 PM
  5. Color chart data points/marker points vba error
    By nmckever in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2014, 07:10 AM
  6. Developing a reusable/simple team chart
    By dweagle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2013, 11:27 PM
  7. [SOLVED] Developing custom chart add-in
    By Ram Shriram in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-04-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1