Bright01
asked on
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
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
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?
ASKER
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
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
It looks like you just want to label the data points. Is that correct?
ASKER
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
B
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
B.
ASKER
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.
B.
Thanks for selecting my "answer" but it really wasn't necessary.