+ Reply to Thread
Results 1 to 5 of 5

Trend chart

  1. #1
    Registered User
    Join Date
    11-11-2016
    Location
    England
    MS-Off Ver
    Office professional plus 2013
    Posts
    3

    Trend chart

    Hello,

    New to this forum so please be gentle with me.

    I have to create a trend chart for several months, the data is very simple.

    I have accounts created per months and account deleted per months, I need to do a chart which represent the possible growth in the coming months

    So on one side I have account creation as follow:

    Month Account creation
    May 23
    June 47
    July 16
    August 12
    September 30
    October 45
    November 18

    And on the other side I have account deleted:

    Account deletion

    Month Account deletion
    May 8
    June 18
    July 1
    August 29
    September 9
    October 17
    November 5

    So, how do I create a chart showing the possible growth forecast of account creation taking in to account the deletion of accounts too?

    Thank you everyone for your help.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Trend chart

    Instead of posting data or pictures, it's usually better to attach a workbook to illustrate the issue. Most of us don't mind working on a solution, but with busy schedules tend to pass over requests where we first have to re-create the workbook and even then might not get it right.

    Please attach a sample workbook with non-sensitive data. It will help us help you.

    To attach a workbook, click on the Go Advanced button and navigate down to the Manage Attachment link - you should be able to follow the prompts and figure it our from there.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    11-11-2016
    Location
    England
    MS-Off Ver
    Office professional plus 2013
    Posts
    3

    Re: Trend chart

    Good point,

    Unfortunately the attachment button is not working for me so I have used filebin.

    Please see workbook located here: http://filebin.ca/31sIf2pGL7kr

    Thank you for your help.

  4. #4
    Registered User
    Join Date
    11-11-2016
    Location
    England
    MS-Off Ver
    Office professional plus 2013
    Posts
    3

    Re: Trend chart

    I have attached the workbook as suggested by you.

    Thank you for your help.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Trend chart

    How about ...

    A
    B
    C
    D
    E
    1
    Month
    Accts Added
    Accts Deleted
    Net Accts
    2
    May
    23
    8
    15
    D2: =B2-C2+N(D1)
    3
    June
    47
    18
    44
    4
    July
    16
    1
    59
    5
    August
    12
    29
    42
    6
    September
    30
    9
    63
    7
    October
    45
    17
    91
    8
    November
    18
    5
    104
    Entia non sunt multiplicanda sine necessitate

+ 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. Time Trend Chart
    By jsboss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-27-2015, 09:28 PM
  2. Trend chart
    By kr1st0f1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-24-2013, 01:19 PM
  3. Trend by day of week chart
    By aggiedawn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-31-2011, 02:13 PM
  4. Bar chart with trend line
    By tani001 in forum Excel General
    Replies: 2
    Last Post: 05-11-2011, 07:04 AM
  5. trend chart
    By camstans in forum Excel General
    Replies: 1
    Last Post: 02-28-2009, 08:55 PM
  6. Bar chart with a trend line
    By Russian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-26-2006, 06:42 PM
  7. [SOLVED] Add target to trend chart
    By Patience in forum Excel General
    Replies: 1
    Last Post: 06-14-2005, 05:05 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