有奖图表练习3：根据工具条变动的图表

北部湾 · 发表于 2008-6-18 06:44

请建立一个根据工具条变动的图表数据如下；（从此贴粘到EXCEL表中即可）<table cellspacing="0" cellpadding="0" width="186" border="0" xstr="" style="WIDTH: 140pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="93" style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 2976;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" width="93" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">2007年</td><td class="xl67" width="93" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">新机夹刀片</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">1月</td><td class="xl67" xnum="143212.03" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">143212.03 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">2月</td><td class="xl68" xnum="150996.09" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">150996.09 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">3月</td><td class="xl68" xnum="203973.00879999998" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">203973.01 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4月</td><td class="xl68" xnum="179633.35979999998" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">179633.36 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">5月</td><td class="xl68" xnum="195373.4418" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">195373.44 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">6月</td><td class="xl68" xnum="194439.64499999999" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">194439.65 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">7月</td><td class="xl67" xnum="152131.535" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">152131.54 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">8月</td><td class="xl67" xnum="170687.68739999994" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">170687.69 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">9月</td><td class="xl67" xnum="177022.08619999999" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">177022.09 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">10月</td><td class="xl67" xnum="156720.57119999995" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">156720.57 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">11月</td><td class="xl67" xnum="174609.5239" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">174609.52 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">12月</td><td class="xl67" xnum="210149.51949999997" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">210149.52 </td></tr></tbody></table>要求做到如动画效果：

有奖图表练习3：根据工具条变动的图表

题目很简单，有现成答案可找。回答正确的会计班学员，每人1币币用回复可见上传动画答案，如有自定义名称，和公式，把自定义名称和公式也粘到答案贴里截止时间1周，即6月25日，公布答案参考答案见3楼

[此贴子已经被作者于2008-6-25 15:09:37编辑过]

殷佳子 · 发表于 2008-6-18 15:29

好象前面建国,沙发

shiwn · 发表于 2008-6-18 19:30

定义名称:data==OFFSET(Sheet1!$A$2,,,Sheet1!$F$1)                data1=OFFSET(Sheet1!$B$2,,,Sheet1!$F$1)

有奖图表练习3：根据工具条变动的图表

[此贴子已经被北部湾于2008-6-25 14:58:22编辑过]

jingtian · 发表于 2008-6-22 10:26

学习来了

jh_richey · 发表于 2008-6-22 14:19

学学

露珠 · 发表于 2008-6-22 19:34

要学习的东西可真不少呀，感谢了。

ZBKYOYO · 发表于 2008-6-23 18:27

游客，如果您要查看本帖隐藏内容请回复

其他操作尼？　　　　北部湾

[此贴子已经被北部湾于2008-6-24 9:49:54编辑过]

zhouyuping · 发表于 2008-6-23 19:03

学习

小华970403 · 发表于 2008-6-23 21:59

游客，如果您要查看本帖隐藏内容请回复

shuijingling · 发表于 2008-6-24 20:03

学习

		自动登录	找回密码
密码			注册