[原创]在PPT中显示动态图表

喵喵

<br /><br /><>我们在excel里制作动态图表是很容易的事情，但是，想要你漂亮的动态图能在PPT上动起来，就要花点心思了。首先你需要有excel制作动态图的基础，其次你需要掌握一点VBA的编写知识，再次还要花点心思去想想怎样控制图表，毕竟PPT的代码和EXCEL的不一样。最后还需要美化一下[em01]</P>
<>源于一个会员的提问，心血来潮，做了一个。</P>
<>原提问贴在这里：<A href="http://www.excelpx.com/forum.php?mod=viewthread&amp;tid=34862">http://www.excelpx.com/forum.php?mod=viewthread&amp;tid=34862</A><BR><BR></P>
<><IMG style="WIDTH: 501px" border=0 alt="" src="http://www.excelpx.com/showimg.asp?BoardID=92&amp;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>&nbsp;&nbsp;&nbsp;</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>PT</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>PT</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>&nbsp;&nbsp;&nbsp;&nbsp;
<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>&nbsp;</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">[hide]&nbsp;</DIV></DIV>
<><BR>[/hide<BR>]<BR></P>
<DIV align=right><FONT color=#000066>[此贴子已经被作者于2010-4-3 11:33:21编辑过]</FONT></DIV>

loren

<p><font style="BACKGROUND-COLOR: #cce8cf;">赞！</font></p>

杰

<p>学习</p>

hhzjxss

<p>谢谢喵喵，昨天好象168院长也做了一个，不知道是不是这个！</p><p></p>

迪斯马斯克

[em01]

xchw1818

这样也行吗??????

小蚂蚁_

学习

yaoxuejian

<p>高手</p>[em01]

wuhan321

把多办公软件的应用，用到了一起，真是活学活用

canlly

<p>看看!</p>