[原创]-Day6.数据可视化之PPT引入

绝地灬酷狼 2022-12-28 15:26 186阅读 0赞

![format_png][]

# PPT中引入Pyecharts #

## 如何把pyecharts 放到PPT? ##

辛辛苦苦用pyecharts做好后，那如何展示给老板们看呢？打工人日常用的最多的展示工具是PPT,这次展示如何把pyecharts放到ppt上？一般把**html文件**放到PPT用两种方法：

![format_png 1][]

### 1、插件 ###

使用`powerpoint`的插件，office apps fiddle for powerpiont

在最新的office已经下架了该插件了，那么只能用第二种方法了。

![format_png 2][]

### 2、VBA ###

**1、在PPT选项卡里添加开发工具**

![format_png 3][]

**2.开发工具-其他控件-microsoft web brower-画透明展示框**

首先看PPT是否开启插件，开启后

此处就有标志，然后就在你想插入的幻灯片处插入**两个控件**

*  1、网页控件

可以自定义拖拽，就会比较大了。

![format_png 4][]

*  2、按钮控件

![format_png 5][]

插入后如下，同理大小位置可自行调整

![format_png 6][]

当然名称也是可以改的 `右键点击按钮 选择属性`

![format_png 7][]

更改`caption属性`（不是名称）

![format_png 8][]

然后开始改代码

`！！！如果PPT 没有开启宏的话 会提醒你开启宏 ，文件须得另存为.pptm格式的宏文件。`

**双击按钮** 会弹出代码界面

![format_png 9][]

`填写代码`

Private Sub WebBrowser1_DownloadBegin()
         WebBrowser1.Silent = True
         End Sub
         Private Sub WebBrowser1_DownloadComplate()
         WebBrowser1.Silent = True
         End Sub
         Private Sub CommandButton1_Click()
         WebBrowser1.Navigate ("C:\Users\DataScience\Desktop\headmap.html")
         End Sub

![format_png 10][]

红线部分为网页链接地址或者下载的模板网页绝对路径

在线编辑echarts 后下载下来 把绝对路径复制到代码中 （1个字符都不能错包括不能多一个空格，否则链接就会错误）

然后放映幻灯片，点击`按钮` OK了

![format_png 11][]

## 效果图如下： ##

![format_png 12][]

## 踩坑记 ##

1.  切记要安装 网页控件 以及 点击控件
2.  切记要打开宏链接
3.  切记路径要绝对 绝对 绝对的准群

## 练习 ##

*  1、讲自己做的图引入到PPT
 *  2、做一个演示的动态可视化

## 福利 ##

本期福利，按照打卡活跃，以及网站留言，进群，凭借手气抽奖

赠送以下书籍（`两本`）

![Image 1][]

**购买链接**

![format_png 13][]

![format_png 14][]

*请添加**小编**,回复关键词：\[**数据可视化**\],*

![format_png 15][]

**-今日互动-**

你的PPT学会了吗？

欢迎文章下方留言互动![format_png 16][]

如果对你有帮助的话

❤️来个「转发朋友圈」和「在看」，是最大的支持❤️

[format_png]: /images/20221120/45c621ad25a24cf28ed2d55af334ea89.png
[format_png 1]: /images/20221120/5b199bdc7cd44697bb92d0ed39e414b3.png
[format_png 2]: /images/20221120/3816c8a3688b443a94ec8ea801dd0925.png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVBuaFY3N3ZmWWlhN3ZoaWJYbWtjRldPYnliVE5wM29lMFI2S2RJVG1ESFJTWjF5M25iYmlham5TZWcvNjQw?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVA5ckJxRE5rVXZDdlJJUWxDT1Bsb3NEWWJwalZKazR4dEpjbWI2Q2wyakNEZjdoZW9hNm5pY2tBLzY0MA?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVBEZ3VsQks0ejdRUjc0YzRPb1U0cWVRSnJXZEdOVGliTXpnZWNpY2lhN0Z4T01EWXg5WFBUb3RVdmcvNjQw?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVBCZUVkYjBoU1FpY04xVmliUFB5RDAwVEl4aWF2M2YzUDhEd3NSN1JpYWMydkFwQ0dvdWFpYUI0T1BsZy82NDA?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVByRVM3OU16NUNuSWExQlNuUnp0Z2ZCTnNlelFlQkdNandXd0QwNWtWNnB5eEFnV0Q4Qnh2RXcvNjQw?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVBRUEZnT3VIaWFFVkE0MnNjeTJib3BmanI3MUh6c280c2ljTWRtME1RdVp4QmJDQjFLdlU2WmxNQS82NDA?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVA0ZDY4WmVRVW1hcTVYaWFjcGZlSWRpYUFmdGpmMWZ0SEhEWUU5RUR4eWRSSnh5bGxFcEM4ejBCZy82NDA?x-oss-process=image/format,png
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVBZV212amxXbEpSZG56VlpKTmpLQ2liTzdEVVFqT2NGM0V4TmZMdkQ1NkFQSko5RzhYTzVqR2JRLzY0MA?x-oss-process=image/format,png
[format_png 11]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVA2NU1jVGp0R090Tmo5OGliWmZQY3pMaWNqbVcySlJaWVhZRUJUeklOQVRpYlZPbDBYZk1ubW9kSkEvNjQw?x-oss-process=image/format,png
[format_png 12]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVBNemNmWHczbmZVMExiV1Y3aWJsR3NlS05JdFpKd2ljdkF3ZkhwSTdJNEpJOVhVUkhLSTF1eWpDdy82NDA?x-oss-process=image/format,png
[Image 1]: https://imgconvert.csdnimg.cn/
[format_png 13]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzNsVjExZmRoMmtFZk01a1BHRExBWVBJUVZ5UHdpYnJwYjYwaWJxc3l5N2VBcEY4Y0JYNG9UMWliVE9iZzFrUjF4enJJU1J0bHZPMnl0YlEvNjQw?x-oss-process=image/format,png
[format_png 14]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9LQ0R1SVR5UDBWemZiWmJ1RmZ5ZGpYZ3c3T1MweE9SUXJpY0hQSGF2NGliY3p2TVc0OXgwM3VvUGliZXRnbklSY2NHdDE4U3Q3bTdJZHN0OW0zM3YyaWJVOFEvNjQw?x-oss-process=image/format,png
[format_png 15]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzIzVXpoaWM3RjhDOWlhV2hCRGJSOW1FYnZTeThRa0NMMUQ5OWF2dWliZWJVUGNucnVVNHl2MzNSTllaaWFhRlRFMWliOXh4M1NxaWNVeWlhWkhnLzY0MA?x-oss-process=image/format,png
[format_png 16]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzJ4RU5mVUZjdDVLNUZ6V053UHVFR3FSSG8zVktXelJjY3RhMkJYaWNHelRRdXNKc0RrWlZZS1BiUUFsY3dVUFA3M0tCYXhHUGV3NWR3LzY0MA?x-oss-process=image/format,png