SOLVED

Creating a single line chart from 3 datasets

%3CLINGO-SUB%20id%3D%22lingo-sub-2113616%22%20slang%3D%22en-US%22%3ECreating%20a%20single%20line%20chart%20from%203%20datasets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113616%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20just%20want%20to%20say%20thanks%20in%20advance%20for%20any%20help%20offered%20to%20my%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20on%20making%20a%20graph.%20I%20thought%20this%20would%20be%20easy%20and%20kind%20of%20showed%20off%20at%20work%20to%20say%20I%20knew%20what%20I%20was%20doing%20but%20am%20failing%20hard.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOK%2C%20here%20is%20what%20I%20am%20trying%20to%20do.%3C%2FP%3E%3CP%3EMake%20a%20cumulative%20line%20graph%20comparing%20a%20series%20of%20values%20from%20Jan%202019%2C%20Jan%202020%20and%20Jan%202021.%3C%2FP%3E%3CP%3EThe%20data%20has%20the%20following%20characteristics.%3C%2FP%3E%3CP%3E(1)%20On%20some%20days%20there%20are%20multiple%20entries%3C%2FP%3E%3CP%3E(2)%20On%20some%20days%20there%20are%20no%20entries%3C%2FP%3E%3CP%3E(3)%20The%20data%20is%20daily%20entries%2C%20not%20cumulative%20(which%20is%20what%20I%20need%20for%20my%20graphs)%3C%2FP%3E%3CP%3E(4)%20I%20have%20date%20and%20value%20for%20January%20in%20the%20three%20years.%3C%2FP%3E%3CP%3EI%20think%20that's%20about%20it.%20I%20quickly%20in%20PowerPoint%20made%20an%20example%20idea%20of%20what%20I%20am%20looking%20for%20to%20hopefully%20give%20some%20insight%20as%20to%20what%20I%20am%20after.%3C%2FP%3E%3CP%3EI%20also%20attach%20a%20random%20generated%20sample%20file%20in%20Excel%20to%20show%20what%20my%20data%20looks%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20thought%20this%20would%20be%20easy%2C%20ideally%20I%20would%20like%20to%20see%20a%20tutorial%20where%20I%20can%20learn%20how%20to%20do%20this%20myself%2C%20but%20I%20am%20reasonable%20at%20Excel%20(at%20least%20I%20thought%20so%20%3Abeaming_face_with_smiling_eyes%3A)%20so%20could%20probably%20follow%20instructions%20or%20replicate%20if%20anyone%20is%20able%20to%20edit%20my%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20I%20said%20at%20the%20start%2C%20many%20thanks%20in%20advance%20to%20the%20group%20for%20any%20help%20provided...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2113616%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2113692%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20single%20line%20chart%20from%203%20datasets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113692%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F954590%22%20target%3D%22_blank%22%3E%40Pete_Murphy40%3C%2FA%3E%26nbsp%3BNo%20rush.%20Come%20back%20here%20if%20you%20need%20more%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2113658%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20single%20line%20chart%20from%203%20datasets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113658%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20your%20quick%20response.%3C%2FP%3E%3CP%3EI%20am%20at%20work%20but%20have%2015%20minutes%20to%20look%20at%20this%20before%20my%20next%20meeting.%20Otherwise%20I%20will%20pick%20it%20up%20at%20the%20end%20of%20the%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20before%20I%20start%20trying%20to%20replicate%20what%20you%20did%20I%20wanted%20to%20quickly%20say%20thank%20you!!!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2113638%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20single%20line%20chart%20from%203%20datasets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113638%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F954590%22%20target%3D%22_blank%22%3E%40Pete_Murphy40%3C%2FA%3E%26nbsp%3BPerhaps%20like%20this.%3C%2FP%3E%3CP%3EAdd%20a%20column%20for%20the%20year.%20Create%20a%20pivot%20table%20by%20year.%20Group%20the%20dates%20by%20day.%20Show%20amounts%20as%20Running%20totals.%20Create%20a%20pivot%20chart%20from%20the%20pivot%20table.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-02-04%20at%2009.00.05.png%22%20style%3D%22width%3A%20401px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252193i817D7CCE3FDB090A%2Fimage-dimensions%2F401x254%3Fv%3D1.0%22%20width%3D%22401%22%20height%3D%22254%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-02-04%20at%2009.00.05.png%22%20alt%3D%22Screenshot%202021-02-04%20at%2009.00.05.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies
best response confirmed by Pete_Murphy40 (New Contributor)
Solution

@Pete_Murphy40 Perhaps like this.

Add a column for the year. Create a pivot table by year. Group the dates by day. Show amounts as Running totals. Create a pivot chart from the pivot table.

Screenshot 2021-02-04 at 09.00.05.png

@Riny_van_Eekelen 

Thank you so much for your quick response.

I am at work but have 15 minutes to look at this before my next meeting. Otherwise I will pick it up at the end of the day.

 

Just before I start trying to replicate what you did I wanted to quickly say thank you!!!!!

@Pete_Murphy40 No rush. Come back here if you need more help.