• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Gartner Hype Cycle

Status
Not open for further replies.

erenm

New Member
How can you produce a Gartner Hype Cycle with excel?

Something like below:

http://www.gartner.com/hc/images/215650_0001.gif
 
yes you can, you will need table like this.

series Type Description Value 1 value 2

1 technology trigger 3D bioprinting 10 10

2 technology trigger Human augmentation 12 12


the series and type are your horizontal axis and your values will be your vertical axis. you will use value 1 as a line graph and value 2 as a scatter pot graph, you will then add your descriptions as data labels for your scatter plot. viola.
 

Faseeh

Excel Ninja
Hi erenm,


Welcome to the forum!!


I am trying to make one for you, and have complete almost 45% of the chart. Hopefully i will upload it by tomorrow eve so till then please wait! :)


Regards,

Faseeh
 

Faseeh

Excel Ninja
Hi erenm,


Sorry for the late response. Here it is:


File: http://dl.dropbox.com/u/60644346/Hyper%20Curve%20IV.xlsx

Image: http://dl.dropbox.com/u/60644346/New%20Picture.bmp


...I hope you will like it, It is almost 90% as that of original pic, some features that are cosmetic might be missing. The biggest issue in its making was that there is no equation given to describe the basic curve (curve in gray color in your pic) so it consumed more time to plot it then to do rest of stuff. Any ways it was a good exercise.


Waiting for your feedback,


Regards,

Faseeh
 

Montrey

Member
holy shit, how did u make that! I can think of some great dashboard implementations for that.


Executives are always wanting to know what happened at certain points on a graph. If I knew ur secrets i could figure something out!


Pure awesome Faseeh
 

Faseeh

Excel Ninja
Hi Chandoo,


Thank you very much. This is a big compliment for me. Thanks you. :D


Yours truly,

Faseeh
 

Caco

New Member
Does anyone have this file yet?? I would really appreciatte if any of you can forward me the excel made by Faseeh
 
Status
Not open for further replies.
Top