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

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

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...

2. 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.

3. 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

#### Posting Permissions

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