# Building Complex Graphic for Crossing Chasm

I'm attempting to build out a complex graphic that replicates the view of "Crossing the Chasm" from Geffrey Moore's work.  Attached is the "desired" attempt vs. actual graphic.

B.
The-Chasm.xls
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Why are you trying to chart it, rather than draw it, as a matter of interest? Does it need to adjust to values you key in?
0
Author Commented:
Rory,

Thanks for asking.  As you know, one of the advantages of digitizing this kind of graphic is to be able to modify it.  I'm planning to plot a "As/Is" and a "To/Be" in the next question to EE.  If it's too difficult to do build out the background graphic, I'll probably use a background image and then plot against it.

B.
0
Commented:
Sort of - what modifications would you actually be making for example?
0
Author Commented:
So,  1.) I think it has to be built out as a normal Bell Shaped Curve with markers for each "Quintile" (text identifier).  Then the gap needs to be a simple blank space gap (perhaps a overlaid graph.  I can live without changing the dimensions of the graphic.  then 2) need to be able to plot two "balls"; an AS/IS and a TO/BE marker based on 1-10 on the vertical axis and 1.00-5.00 on the horizontal axis.

Make sense?

B.
0
Author Commented:
Rory,

Perhaps this is too complex.  How about a simple Bell Shaped Curve graph where we can also plot two data points on the X and Y Graph?  I could fill in the Quintiles with text to recreate the graphic.

Would that work?

B.
0
Commented:
Apologies - I have been busy with other things. I will try and have another look at this tomorrow.
0
Author Commented:

b.
0
Commented:
What do the 1-10 values represent? (given there is no vertical scale)

It may be easier to create a background graphic for the bell curve and then simply plot the XY over the top.
0
Author Commented:
Agree.  However, a Excel Bell Curve would be helpful.  So the 1-10 on the vertical access as an overlay graphic would be a "score" that is calculated from a set of questions....beyond the scope of this graphic but will feed the two points that are plotted (As/Is and To/Be).

Make sense?

B.
0
Commented:
Possibly. :)

Here's where I'm at for now - fairly rough and ready, and the plotting of the two text data points needs some work!
The-Chasm.xlsx
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:
Good start!   If I change the "names" (e.g. pragmatist), the label doesn't change.........

But far better then I could have  done!

B.
0
Commented:
Sorry - I haven't linked the column headers on the second sheet to the cells on the first. if you do that, they should update.
0
Author Commented:
OK.... I linked the Text but how do I link the values?

B.
0
Commented:
What values?
0
Author Commented:
Do these values have any meaning to the graphic?

Quentile      Value
Enthusiasts      2      2
Visionaries      6      8
Chasm      0      8
Chasm      0      8
Pragmatists      12      20
Conservatives      6      26
Skeptics      2      28
0
Author Commented:
Rory,

Sorry for the delay..... the graphic works perfectly.  Thank you so much for your help with this.  I'm surprised that it was "doable"!

Best regards,

B.
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.