Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • Last Modified:

Three Dimensional Journey Map in Excel

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
Bright01
Asked:
Bright01
  • 4
  • 4
1 Solution
 
Martin LissOlder than dirtCommented:
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
 
Bright01Author Commented:
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
 
Martin LissOlder than dirtCommented:
It looks like you just want to label the data points. Is that correct?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Bright01Author Commented:
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
 
Martin LissOlder than dirtCommented:
Sorry but I don't think I can help you on this one.
0
 
Bright01Author Commented:
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
 
Bright01Author Commented:
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
 
Martin LissOlder than dirtCommented:
Thanks for selecting my "answer" but it really wasn't necessary.
0
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now