带连接器文本的Visio组织图
我整天（未能成功）尝试创建一个ORG图表，该图表显示一个变量为连接器文本。
我不是开发人员，也不是Visio的新手。
基本上，我的数据看起来像这样：
| ID | 名称 | reports_to | Connector_txt |
|---|---|---|---|
| 1 | 个人A | ||
| 2 | 个人B | 1 | Direct |
| 3 | Persh 3 Persion C | 1 | Direct |
| 4 | Persion 4 Persion 4 Persion 4 Persion D | 2 | Legal |
| 5 | Persion E | 2 | Direct |
| 6 | Persive 6 Persion | 6 Persion 6 | 财务 |
请注意，显示文本很重要在连接器上方而不是形状。 此外，数据必须连接到Excel文件，以便可以将其维护在Excel中，而Visio仅用于可视化。因此，该解决方案应无需手动调整所有内容而起作用。
我还尝试了流程图等。但是它们看起来完全凌乱（不仅是从上到下）。但是，如果它产生干净的垂直视觉（没有泳道等），则通常可以使用另一个模板来使用另一个模板。
非常感谢您对此的任何想法：）
奖金：如果有可能从Excel数据中与团队框架或容器分组（例如，通过添加一列“部门”），那真是太棒了！
编辑：这是一些手动创建的视觉效果，内容涉及我希望它看起来像 org图表
I've tried all day (unsuccessfully) to create an org chart that displays a variable as the connector text.
I am not a developer and new to visio.
Basically, my data looks like this:
| ID | Name | Reports_to | Connector_txt |
|---|---|---|---|
| 1 | Person A | ||
| 2 | Person B | 1 | direct |
| 3 | Person C | 1 | direct |
| 4 | Person D | 2 | legal |
| 5 | Person E | 2 | direct |
| 6 | Person F | 3 | financial |
Please note that it is important to display the text above the connector and not within the shape.
Further, the data has to be connected to an Excel file so that it can be maintained in Excel and Visio is just used for visualization. Hence, the solution should work without manually adjusting everything, all the time.
I also tried flow charts etc. but they look totally messy (not simply top to bottom). But I am generally open to using another template than "org chart" if it results in a clean vertical visual (no swimlanes etc.).
Thank you so much for any thoughts on this :)
Bonus: If it would be possible to group persons with team frame or container from the excel data (e.g., by adding a column "department") that would be awesome!
EDIT: Here is some manually created visual on how I wanted it to look like
Org Chart with Connector Text
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我不知道Visio内置的图表解决方案足以说这是不可能的，但是我会让Visio像它一样生成图表，并且只有在此之后才能在收集Reports_to和Connector_text的图纸上运行一个宏属性，标识正确的连接器，最后将其文本设置为所需的值。
您说，您不是开发人员，我敢肯定我们可以在此问题上提供帮助。
您的第二个愿望也一样。
I don't know Visio's built in Charting solutions enough to say it is not possible out of the box, but I would let Visio generate the chart as it does and only after this would run a macro over the drawing that collects the Reports_to and Connector_text properties, identifies the right connector and finally sets it text to the desired value.
You said, you're not a developer, I'm sure we can help in this matter.
Same for your second wish.