[原创]在PPT中显示动态图表
本帖最后由 东门吹雪 于 2012-9-1 09:09 编辑 <br /><br /><P>我们在excel里制作动态图表是很容易的事情，但是，想要你漂亮的动态图能在PPT上动起来，就要花点心思了。首先你需要有excel制作动态图的基础，其次你需要掌握一点VBA的编写知识，再次还要花点心思去想想怎样控制图表，毕竟PPT的代码和EXCEL的不一样。最后还需要美化一下</P><P>源于一个会员的提问，心血来潮，做了一个。</P>
<P>原提问贴在这里：<A href="http://www.excelpx.com/forum.php?mod=viewthread&tid=34862">http://www.excelpx.com/forum.php?mod=viewthread&tid=34862</A><BR><BR></P>
<P><IMG style="WIDTH: 501px" border=0 alt="" src="http://www.excelpx.com/showimg.asp?BoardID=92&filename=2010-4/20104311305784585.gif" width=501 height=322></P>
<DIV class=O vshape="_x0000_s1026">
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial"><FONT color=#3300ff>制作步骤简述：</FONT><BR> </SPAN></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>1</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">，插图列表框，编写事件代码生成列表 </SPAN></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>2</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">，插入对象，选</SPAN><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial"> Microsoft Excel </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">工作表 </SPAN></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>3</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">，编辑工作表数据，调试好显示的区域和图表的格式，设定动态区域的关联单元格。</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">并设置好动在</SPAN><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>excel</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">显示的态图表。 </SPAN></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>4</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">，在</SPAN><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>PPT</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">中插入标签作为选项 （为了好看，否则用复选框也一样的）</SPAN></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>5</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">，在</SPAN><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>PPT</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">中插入图片作为每个选项指示的标志，选中和不选中标志各一，并重叠排放 </SPAN></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN" lang=EN-US>6</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">，写列表框和选项代码，以控制插入的工作表里动态关联的单元格。<SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial">（也可以插入复选框代替标签和指示图片）</SPAN><BR>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial"></SPAN></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><SPAN style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial"><FONT size=4><STRONG><FONT color=#ff00ff size=3>注意，如果下载后没效果，请把PPT中宏的安全性设置为中</FONT>。</STRONG></FONT></SPAN></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"></DIV></SPAN> </DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"><FONT color=#0000ff>附件下载：</FONT></DIV>
<DIV style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1"> </DIV></DIV>
<P><BR><BR></P>
<DIV align=right><FONT color=#000066>[此贴子已经被作者于2010-4-3 11:33:21编辑过]</FONT></DIV>