+ Reply to Thread
Results 1 to 2 of 2

How to create visual forecast

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    nyc
    MS-Off Ver
    Excel for Mac 2011 Version 14.3.6
    Posts
    1

    How to create visual forecast

    I have the following data and would like create a forecast to provide my development team with a heads up on the number of users I expect to hit our server. Does anyone know how to easily do this? Appreciate the help!

    Data of multiple programs:
    Program Start Date
    Program End Date
    Forecast of Daily Users

    I would like to create a line chart that shows the sum of forecasted daily users across all programs:
    x-axis: time
    y-axis: number of forecasted users

    Thank you!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: How to create visual forecast

    maybe something like this.

    A line chart with dates in first column.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Forecast Variance and Percent - need help with hours forecast
    By hoppythyme in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-24-2013, 08:37 PM
  2. Challenging Forecast Wape - Rolling 12 Month Sum Of Orders And Forecast
    By nguyeda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2013, 06:20 PM
  3. Replies: 0
    Last Post: 11-26-2012, 03:15 AM
  4. Create a Forecast table with dynamical period range
    By dreams in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-17-2009, 08:48 AM
  5. [SOLVED] Trying to create a Sales Projection/Forecast/Estimate
    By S L Pace in forum Excel General
    Replies: 3
    Last Post: 03-30-2005, 10:06 AM

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