+ Reply to Thread
Results 1 to 1 of 1

Line graph needed to forecast 2018 savings

  1. #1
    Registered User
    Join Date
    07-07-2017
    Location
    Adelaide, Australia
    MS-Off Ver
    2016
    Posts
    3

    Line graph needed to forecast 2018 savings

    Hi,

    Referring to the Data Worksheet attached
    I need to generate a line graph that shows 3 sets of data for expected savings to be achieved in year 2018.

    Carryover savings (from 2017)
    Realised saving 2018
    Carryover savings + Realised Savings

    The savings are based on a 12 month period. If savings begun to be realised on 1st July 2017, then 50% would be realised in 2017 and the other 50% in 2018.

    Graph range is 'year 2018' in monthly increments (x axis) and Y axis is Savings value in Euros
    Graph Line 1 = the sum of column AN (358742) is to be plotted for each month
    Graph Line 2 = Column AQ but each month it accumulates
    Example
    in Jan 2018 there is no savings.
    in Feb 2018 there will be 4575 savings
    in Mar 2018 there will be 4611 savings + 4575 savings from Feb = 9186
    in Apr 2018 there will be 8288 savings + 9186 from Feb/mar =17474
    in May 2018 there will be 8390 savings + 17474
    etc etc until Dec 2018

    Graph Line 3 = the sum of line 1 + line 2 for each month ie Feb would equal 358742 +4575, march would equal 358742 + 9186 and so on.

    thanks for your help.
    Attached Files Attached Files
    Last edited by AliGW; 07-14-2017 at 03:12 AM.

+ 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. Savings Forecast
    By mikecoll in forum Excel General
    Replies: 1
    Last Post: 11-02-2016, 01:21 PM
  2. [SOLVED] APpend forecast line to actual value line
    By BRISBANEBOB in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-16-2016, 03:22 AM
  3. Updating existing 4 line graph is giving single line graph
    By carrach in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-15-2016, 07:53 AM
  4. Help needed on line graph..
    By mahershams in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-19-2012, 09:39 AM
  5. Line Graph (Actual plus forecast data)
    By arun2681 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-28-2012, 06:49 PM
  6. Replies: 1
    Last Post: 04-11-2012, 10:26 AM
  7. Line graph data series help needed!
    By jackdsargeant in forum Excel General
    Replies: 1
    Last Post: 11-07-2010, 04:58 PM

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