Results 1 to 3 of 3

Thread: Making a single Line Chart from 3 Data Sets (harder than I thought it would be :-)

  1. #1
    Neophyte Pete_Murphy's Avatar
    Join Date
    Feb 2021
    Posts
    1
    Articles
    0
    Excel Version
    365 and 2016 (home and work)

    Making a single Line Chart from 3 Data Sets (harder than I thought it would be :-)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all, just want to say thanks in advance for any help offered to my problem.

    Please help me on making a graph. I thought this would be easy and kind of showed off at work to say I knew what I was doing but am failing hard.

    OK, here is what I am trying to do.
    Make a cumulative line graph comparing a series of values from Jan 2019, Jan 2020 and Jan 2021.
    The data has the following characteristics.
    (1) On some days there are multiple entries
    (2) On some days there are no entries
    (3) The data is daily entries, not cumulative (which is what I need for my graphs)
    (4) I have date and value for January in the three years.
    I think that's about it. I quickly in PowerPoint made an example idea of what I am looking for to hopefully give some insight as to what I am after.
    I also attach a random generated sample file in Excel to show what my data looks like.


    I really thought this would be easy, ideally I would like to see a tutorial where I can learn how to do this myself, but I am reasonable at Excel (at least I thought so &#128513 so could probably follow instructions or replicate if anyone is able to edit my file.


    As I said at the start, many thanks in advance to the group for any help provided...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	ExampleImageOfGraph.JPG 
Views:	5 
Size:	47.9 KB 
ID:	10321  
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,913
    Articles
    0
    Excel Version
    365
    Add a column C to your source data calculating just the year component of alll the dates
    Add apivot table and chart as shown.
    Check the values are correct.
    Click image for larger version. 

Name:	2021-02-05_005352.png 
Views:	6 
Size:	16.8 KB 
ID:	10324
    Attached Files Attached Files

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,913
    Articles
    0
    Excel Version
    365
    oh groan…

    cross posted without links:
    https://www.myonlinetraininghub.com/...rom-3-datasets

    Pete_Murphy, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Tags for this Thread

Posting Permissions

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