How to make a chart that shows the number of requests submitted during a week, the number of requests executed during that week, and the number of still pending requests that have been submitted that week or previously that have not yet been executed?
I have three columns.
In column A are unique record numbers for individual requests.
In column B are the dates that each request was submitted.
In column C are the dates that each request was executed.
I would like to make a chart that shows the number of records submitted and executed on a weekly basis as two separate bars, then I would like to have a third bar that shows the total number of records that have been submitted either in that week or previously but are still not executed.
I have been trying to set this up in a pivot table with some success but I can't quite figure it out. Honestly I'm not sure if a pivot table is the right way to this.
Using Excel 2016.
Sample data below.
Any help would be much appreciated. :)
| Request Reference Number | Submitted Date | Executed Date |
|---|---|---|
| 1 | 12/3/2020 | 12/11/2020 |
| 2 | 12/3/2020 | 12/20/2020 |
| 3 | 12/3/2020 | 12/10/2020 |
| 4 | 12/4/2020 | 1/19/2021 |
| 5 | 12/7/2020 | 12/22/2020 |
| 6 | 12/8/2020 | 12/21/2020 |
| 7 | 12/13/2020 | 1/15/2021 |
| 8 | 12/13/2020 | 00/00/00 |
| 9 | 12/21/2020 | 1/20/2021 |
| 10 | 1/6/2021 | 00/00/00 |
Posted Feb 3, 2021, 9:30 PM UTC · edited
u/Scuzzbopper - please read this comment in its entirety.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.