Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

MS Excel Challenge

  • 11-09-2018 11:26AM
    #1
    54and56
    Registered Users, Registered Users 2, Paid Member Posts: 8,051 ✭✭✭54and56


    Not sure if this is the right place to ask this but for the life of me I cannot replicate how to create this graph in Excel.

    Anyone got any suggestions?

    Excel-Chan1536665203.png


Comments

  • #2
    Mathias Gentle Deodorant
    Posts: 81,309 CMod ✭✭✭✭ Mathias Gentle Deodorant


    it looks like a 2d area graph with the x axis formatted to be on top... or do you mean you dont have the data?


  • #3
    verycool
    Closed Accounts Posts: 965 ✭✭✭verycool


    Also looks like a trendline with some neat formatting.

    https://support.office.com/en-US/article/Add-a-trend-or-moving-average-line-to-a-chart-fa59f86c-5852-4b68-a6d4-901a745842ad


  • #4
    ozmo
    Registered Users, Registered Users 2 Posts: 3,893 ✭✭✭ozmo


    Looks to be a "Fan Chart"... nicely formatted.

    https://peltiertech.com/excel-fan-chart-showing-uncertainty-in-projections/

    “Roll it back”



  • #5
    54and56
    Registered Users, Registered Users 2, Paid Member Posts: 8,051 ✭✭✭54and56


    Wow, serious suggestions there guys.

    I'll dive into them and see if I can replicate it.


  • #6
    54and56
    Registered Users, Registered Users 2, Paid Member Posts: 8,051 ✭✭✭54and56


    bluewolf wrote: »
    it looks like a 2d area graph with the x axis formatted to be on top

    Never knew you could move the X axis to the top but will figure out how to do so!
    bluewolf wrote: »
    or do you mean you don't have the data?

    I don't have the actual data but am familiar with what it should look like so should be able to re-create my own version. It's like a moving normal distribution where each point on the X (top) axis has a range of probable values across 3 or 4 standard deviations thus forming the "wave" effect as the x axis value increases. (If that makes any sense!)


  • Advertisement
  • #7
    Mathias Gentle Deodorant
    Posts: 81,309 CMod ✭✭✭✭ Mathias Gentle Deodorant


    Je_suis_Jean wrote: »
    Never knew you could move the X axis to the top but will figure out how to do so!



    I don't have the actual data but am familiar with what it should look like so should be able to re-create my own version. It's like a moving normal distribution where each point on the X (top) axis has a range of probable values across 3 or 4 standard deviations thus forming the "wave" effect as the x axis value increases. (If that makes any sense!)

    Cool you should be set so. you should get the wave effect if there's a different series for each result
    you can right click on the x axis when the graph is made, format axis, then there is a little dropdown with high/low/something else. select high and it'll do the job


Advertisement