+ Reply to Thread
Results 1 to 1 of 1

Scatter with smooth lines - Dual data over time (including unwritten null days)?

  1. #1
    Registered User
    Join Date
    06-27-2011
    Location
    Springfield, Missouri
    MS-Off Ver
    Excel 2016
    Posts
    16

    Scatter with smooth lines - Dual data over time (including unwritten null days)?

    Greetings,

    I am trying to do a visual chart using something like 'scatter with smooth lines', and I need this chart to include the days that have a null/0 value for both data sets.

    First column = Data (YYYY/MM/DD)
    Second column = Dataset A
    Third column = Dataset B

    First row = Headers for each column ("Date", "Chocolates eaten", "Pizza slices eaten")

    Only the days that had activity were recorded. But I need the graph to show the days that I never recorded too.

    In the end I want to be able to look at a graph showing a smooth-curve representation of both datasets on the same graph over time (to try and see if there are any emerging patterns such as particular times of the year or month certain events are prone to occur, etcetera). The "scatter with smooth lines" is useful because of the smooth curve, the projection line that can be added based on averages of the dataset(s), and because the curve will not be absolutely contrasting between days with 0 activity -> high activity -> 0 activity -> high activity. ;o

    I've messed around with this for hours and I can't figure out how to do this.

    Thanks, all help appreciated!

    EDIT: Actually, nevermind. All I had to do was select the datasets+date and insert scatter. I wish I could somehow present it more nicely -- I have to make the width of the graph extremely huge so that it would show all data
    Attached Files Attached Files
    Last edited by BlueToast; 09-05-2011 at 02:58 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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