Solved

Three Dimensional Journey Map in Excel

Posted on 2016-11-29
8
50 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 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