+ Reply to Thread
Results 1 to 4 of 4

Trying to create a line graph with "cone of uncertainty", maybe a slider too

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    10

    Trying to create a line graph with "cone of uncertainty", maybe a slider too

    Aloha, I'm trying to create a combo bar/line graph showing enrollment projections for my school.

    I found the attached "Retired Financial Planner1.xlsx" template in Excel, thought it was cool, want to do something similar.

    My document is attached (enrollment projections.xlsx). I started a simple combo graph, just want to beef it up like the retiree planner example. I'd like to add a cone of uncertainty to my line graph's projected data. Would also like to add a slider or some sort of interactive object to make the chart respond to changes in the data, if that's doable.

    If this too much work, no worries... will be sure to give you a shout out in my presentation, though.
    Attached Files Attached Files

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

    Re: Trying to create a line graph with "cone of uncertainty", maybe a slider too

    The retirement planner appears to use a technique similar to this area/XY combination plot: http://peltiertech.com/fill-under-be...n-excel-chart/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: Trying to create a line graph with "cone of uncertainty", maybe a slider too

    A little late to the party, but this sounds like my tutorial Excel Fan Chart Showing Uncertainty in Projections.
    Jon Peltier
    http://PeltierTech.com/

  4. #4
    Registered User
    Join Date
    09-27-2012
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    10
    Quote Originally Posted by Jon_Peltier View Post
    A little late to the party, but this sounds like my tutorial Excel Fan Chart Showing Uncertainty in Projections.
    Thank you! Excellent work and thanks for sharing.

+ 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: 1
    Last Post: 08-15-2014, 06:00 AM
  2. [SOLVED] Line graph with secondary axes is not treated as xlLine in "select case"
    By Joachimjr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2014, 09:41 AM
  3. Replies: 0
    Last Post: 04-08-2013, 08:02 AM
  4. Need to "not show" piece of line in graph
    By Callan in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-07-2005, 11:05 PM
  5. How do I "index" data in a line graph?
    By ShirleyJL in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-10-2005, 07:06 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