r/excel•
Scuzzbopper

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?

unsolved

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 NumberSubmitted DateExecuted Date
112/3/202012/11/2020
212/3/202012/20/2020
312/3/202012/10/2020
412/4/20201/19/2021
512/7/202012/22/2020
612/8/202012/21/2020
712/13/20201/15/2021
812/13/202000/00/00
912/21/20201/20/2021
101/6/202100/00/00

​

Posted Feb 3, 2021, 9:30 PM UTC · edited

11
AutoModeratorMOD•

u/Scuzzbopper - please read this comment in its entirety.

  • Read the rules -- particularly 1 and 2
  • Include your Excel version and all other relevant information
  • Once your problem is solved, reply to the answer(s) saying Solution Verified to 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.

1