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.

Thank you in advance,

B.
The-Chasm.xls
Bright01Asked:
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.

Rory ArchibaldCommented:
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
Bright01Author 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.

Does that answer your question?

B.
0
Rory ArchibaldCommented:
Sort of - what modifications would you actually be making for example?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Bright01Author 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
Bright01Author 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
Rory ArchibaldCommented:
Apologies - I have been busy with other things. I will try and have another look at this tomorrow.
0
Bright01Author Commented:
No worries!  Appreciate your help.  

b.
0
Rory ArchibaldCommented:
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
Bright01Author 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
Rory ArchibaldCommented:
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

Your issues matter to us.

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

Start your 7-day free trial
Bright01Author 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
Rory ArchibaldCommented:
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
Bright01Author Commented:
OK.... I linked the Text but how do I link the values?

B.
0
Rory ArchibaldCommented:
What values?
0
Bright01Author 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
Bright01Author 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.