据我所知仅限Visio FlowChart和组织结构图可以根据数据库自动生成图表。

As far as I know for Visio only FlowChart and Organization Chart can generate Chart automatically based on database.

根据您的要求，Visio中的功能无法实现。

For your requirement, it is not possible by feature in Visio.

For VBA，我建议你尝试将这个问题发布到G 通用办公室开发论坛：

For VBA, I suggest you try to post this question to General Office Development forum:

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=officegeneral

我们建议适当发布的原因是您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。谢谢为了你的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

希望你能在那里得到帮助。

Hope you can get help there.

问候，

Emi

Emi