Solved

Three Dimensional Journey Map in Excel

Posted on 2016-11-29
8
56 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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

 

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem with a moving column in Excel 6 42
first name and last initial in excel 11 29
remove extra space at end of cell 12 32
extract a substring between backslashes from paths 10 22
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

828 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