Graph using multiple date columns

kmoreau48

New Member
Joined
Aug 6, 2014
Messages
11
I have a simple table where I am tracking the status of a long list of items (around 500 for now)
I have a column for each of the following :
1. Sent for fabrication
2. Expected completion date
2. Delivered to paint shop
3. Delivered to work site

I am trying to make a graph with the dates inside those 4 columns but since the dates from each columns are different, I am having a hard time making a graph that will show me a comparison between those columns.
My main data would be the expected completion date since some of those date will be in the future. One of the issue I have is that the date for the expected completion is a formula that gets the date from another sheet and my pivot table does not seem to like that.

I was able to come up with a graph by using the column "sent for fabrication" as a "row" in my pivot table, made each column as a running total and grouped the dates in 7 days. Then I make a graph and it looks somewhat like what I expect but I dont have the future date of the "expected completion date" in the graph.

Any idea how I can better use the data in order to show it on a graph and have a visual if we are behind or on track to what was expected?
I attached a preview of the data and the result I am getting



Also, here is my excel workbook : Suivi Pré-Fab_Valéro_2022-04-19.xls
 

Attachments

  • Capture d’écran 2022-04-24 075035.png
    Capture d’écran 2022-04-24 075035.png
    75.9 KB · Views: 79
  • Capture d’écran 2022-04-24 075244.png
    Capture d’écran 2022-04-24 075244.png
    16.8 KB · Views: 77
  • Capture d’écran 2022-04-24 075341.png
    Capture d’écran 2022-04-24 075341.png
    46.7 KB · Views: 77

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top