+ Reply to Thread
Results 1 to 3 of 3

Need help on Growth chart

  1. #1
    Registered User
    Join Date
    10-25-2004
    Location
    Massachusetts USA
    MS-Off Ver
    Microsoft 365 for Enterprise (Excel Version 2302)
    Posts
    69

    Need help on Growth chart

    Friends,
    I need to build a graph that shows sales growth from a given base line to a target, incrementally every year. For eg:

    Baseline (Year 0): $50M
    Year 1: -$3M [meaning we will degrow by 3 million to $47M]
    Year 2: $5M (grow by $5M more from $47M to $52M]
    Year 3: $4M
    Year 4: $4M [Reached target of $60M]

    The graph should look like:
    first bar is for 50M and sets a baseline (draw a line)
    second bar is shown as -3M - down from this baseline
    third bar is shown as 5M from this etc..
    until we reach the 60M target.

    Can someone help please

    Thanks a lot.

  2. #2
    Registered User
    Join Date
    10-25-2004
    Location
    Massachusetts USA
    MS-Off Ver
    Microsoft 365 for Enterprise (Excel Version 2302)
    Posts
    69

    Re: Need help on Growth chart

    Am attaching a ppt slide to describe the requirement.
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,813

    Re: Need help on Growth chart

    Your picture/chart looks like a standard waterfall/bridge chart with a single horizontal line added to it.

    Waterfall/Bridge chart tutorial: http://peltiertech.com/excel-waterfa...bridge-charts/
    Adding a horizontal line to a chart: http://peltiertech.com/Excel/Charts/AddLine.html

    Review those tutorials, then let us know where you get stuck.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Replies: 8
    Last Post: 11-24-2015, 11:32 AM
  2. sales growth vs. headcount growth for recent years
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-15-2015, 04:24 AM
  3. create chart for customer growth vs. expense growth
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-06-2015, 01:19 PM
  4. Interpolate monthly growth from known Annual Growth
    By nopointing in forum Excel General
    Replies: 3
    Last Post: 06-15-2014, 03:36 AM
  5. Help creating a segment chart with growth
    By 198four in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-12-2013, 05:18 PM
  6. bar chart formula to show the number growth
    By dpatel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2013, 10:32 AM
  7. Formula for growth chart?
    By DORI in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-22-2005, 09:15 PM

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