0 Replies Latest reply on Oct 27, 2012 10:44 AM by bruce lomasky

    Graph to show warehouse (usage) capacity over time

    bruce lomasky

      I am trying to create a graph that will show the warehouse current usage (in Sq Ft) over time.  There are two "plug" numbers.  One is the starting quantity (as of today), the other is the daily usage (shipments) in sq feet.  I have a data extract with 2 columns of anticipated purchase order receipts.  One the due date and the other the total sq feet due in.  (this is all in the attached workbook).  I am not sure how to proceed in turning the bar chart dates Sq. Ft. due into a line chart showing the expected usage over "X' period.

       

      Thanks

       

      Bruce