Feb 03 2021 11:20 PM
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 :beaming_face_with_smiling_eyes:) 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...
Feb 04 2021 12:01 AM - edited Feb 04 2021 12:04 AM
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.
Feb 04 2021 12:13 AM
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!!!!!
Feb 04 2021 12:57 AM
@Pete_Murphy40 No rush. Come back here if you need more help.
Feb 04 2021 12:01 AM - edited Feb 04 2021 12:04 AM
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.