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

# 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".
0
Bright01
• 4
• 4
1 Solution

Older 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?
0

Author 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.

B.
0

Older than dirtCommented:
It looks like you just want to label the data points. Is that correct?
0

Author 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

Older than dirtCommented:
Sorry but I don't think I can help you on this one.
0

Author 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

Author 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

Older 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.