Solved

Three Dimensional Journey Map in Excel

Posted on 2016-11-29
8
43 Views
Last Modified: 2016-12-01
EE Pros,

This is a Excel Charting exercise and not for the faint at heart. However, I have searched the Web and EE and cannot find anything like it.  So this may be a first.  The idea is simple.  There are 3 points (X, Y and Z).  X is a Date that needs to be properly spaced to reflect dates inputted. The Y is a Value amount (i.e. $).  The Points are a simple Line Plot.  So far....pretty simple.

Here's the ask, The Z represents "TEXT LABELS" that need to be reflected at each Plot Point.  Given the text may change, it needs to adapt to the amount of text (probably no more then 2 sentences at pt.8 type.

Take a look and engage if you think you have an approach to do this.  And..... as always, "Thank you in advance".
Roadmapv2.xlsm
0
Comment
Question by:Bright01
  • 4
  • 4
8 Comments
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41906481
Can you show a picture, even if hand-drawn, of what you'd like the chart to look like? Also are you aware that the are existing 3D-looking charts like this "3-D Cylinder" version?
3D
0
 

Author Comment

by:Bright01
ID: 41906488
Martin,

Greetings.  Yes, I'm familiar with the 3-D charting.  This is different.  Here is a picture (Conceptual).  The Workbook I attached shows the data (X, Y and Z).  The tricky part is how do you get the Labels on the right data points.

Thanks again for comments.

B.
Roadmap-Graphic.ppt
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41906529
It looks like you just want to label the data points. Is that correct?
0
 

Author Comment

by:Bright01
ID: 41907078
Well, it's a little more complicated then that.  Label the Data/Label Points?   "YES".  Have them move, resize the label box and change based on changes to the X and Y coordinates or the Text for the Label?  "that would be the magic".  :-)

B
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 46

Accepted Solution

by:
Martin Liss earned 500 total points
ID: 41907168
Sorry but I don't think I can help you on this one.
0
 

Author Comment

by:Bright01
ID: 41907183
Martin,  if you can't do this, then I doubt it can be done or is a sizeable project.  I'll give it another couple of hours and if nothing.... I'll close it out.  As always, appreciate your insight.

B.
0
 

Author Closing Comment

by:Bright01
ID: 41908360
Martin, appreciate and respect your opinion on this.  If you can't do this in a few keystrokes, I'm rethinking my ask and will eventually trim this question back to something reasonable and doable.  Thanks, as always for taking a look and rendering advice.

B.
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 41908943
Thanks for selecting my "answer" but it really wasn't necessary.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to read BOM (Byte Order Mark) from csv file. 4 36
Excel case statements 3 24
Help with Excel formula 6 35
the code is not looping through 11 24
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now