Forum Discussion
Solved
Creating a single line chart from 3 datasets
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 w...
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.
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.
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.