+ Reply to Thread
Results 1 to 1 of 1

To create Waterfall Chart for Production,Opening Inventory Sales and Closing Inventory

  1. #1
    Registered User
    Join Date
    09-04-2018
    Location
    saudi arabia
    MS-Off Ver
    2016
    Posts
    1

    Post To create Waterfall Chart for Production,Opening Inventory Sales and Closing Inventory

    Dear All,

    I am newbie for Waterfall chart. My boss give me this instruction to create a waterfall chart for the following;

    Task 1;
    From the data for production, sales, opening inventory, calculate the total closing inventory and show in a waterfall graph how it was made up from different products

    Task 2;
    Make up a waterfall graph that shows the make up and also the total product available as a subtotal (production+ opening inventory) and from this subtotal show the sales and a final total ( which will be the closing inventory)
    this is to be shown in one combined graph, not two separate waterfall graphs.

    I made something which I am not sure if I did it correctly and reflected his requirement. I hope that I can receive feedback from the good members here. TIA
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using up inventory codes for production
    By ritzucf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2017, 07:15 PM
  2. SUMIFS + LOOKUP? Inventory management combined with production schedule
    By VladKyle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-11-2015, 02:16 PM
  3. Replies: 0
    Last Post: 04-14-2014, 10:06 PM
  4. Replies: 1
    Last Post: 10-28-2013, 11:34 AM
  5. Want to set Week End Inventory #s to load in Opening Inventory
    By tkeat1692 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2013, 08:58 PM
  6. Want to set Week End Inventory #s to load in Opening Inventory
    By tkeat1692 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2013, 11:24 PM
  7. Production and Inventory adjustment??
    By zx7r in forum Excel General
    Replies: 4
    Last Post: 01-13-2012, 10:41 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1