18号图表课的疑问汇总

北部湾 · 发表于 2008-5-18 06:37

18号图表课的疑问汇总请付论坛币币报名上图表课的会计班学员对上课内容有没能理解的倒此跟贴提问仅付论坛币币报名上课的学员哦，其他人勿水 hxqzccct老师的课件

Rv97J9FK.rar (8.92 KB, 下载次数: 12)

北部湾 · 发表于 2008-5-18 19:18

图表一：自动更新我们通常做的图表可以因为数据源中的数值的变动而进行小范围的变动，可数据源发生增减，就不会相应增加，手工重新设置数据源太麻烦，在做图表前把数据源人为设大，图表会留大段空白太难看。现在来做个图表，当图表数据源发生增减时，图表自动增减而不必再人工更改设置。

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

[此贴子已经被作者于2008-5-19 13:41:15编辑过]

北部湾 · 发表于 2008-5-18 19:18

图表二：根据下拉框来显示对应图表内容通常我们做的图表都是按开始设计图表时的数据源做的图表，如果数据源有多类同种数据，我们不是把多类放在一张图表上（看起来好累），就是分别做N张图表（重复工作，做起来好烦）现在来做个图表，可以根据图表里的下拉框的选择，自动变化，只做一个图表，就等于做了N个图表

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

[此贴子已经被作者于2008-5-19 14:18:03编辑过]

北部湾 · 发表于 2008-5-18 19:19

图表三：动态图表 这是**公司2007年库房情况表  <table cellspacing="0" cellpadding="0" width="442" border="0" xstr="" style="WIDTH: 333pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="93" style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 2976;"></col><col></col><col width="102" style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3264;"></col><col></col><col width="91" style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 2912;"></col><col></col><col width="54" style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1728;"></col><col></col><col width="102" style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3264;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" 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="xl26" width="102" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 77pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">1月</td><td class="xl26" width="91" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 68pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">2月</td><td class="xl26" width="54" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 41pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" width="102" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 77pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">12月</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" 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;">新机夹刀片</td><td class="xl26" 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><td class="xl27" 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><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" 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><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" 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;">旧机夹刀片</td><td class="xl26" xnum="130023.05" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">130023.05 </td><td class="xl27" xnum="127944.952" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">127944.95 </td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" xnum="102624.06780000002" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">102624.07 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" 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;">焊接刀片</td><td class="xl26" xnum="200326.36" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">200326.36 </td><td class="xl27" xnum="263845.0502" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">263845.05 </td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" xnum="219075.55469999992" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">219075.55 </td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl28" height="21" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;">…</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">…</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" 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;">数控刀杆</td><td class="xl26" xnum="24123.86" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">24123.86 </td><td class="xl27" xnum="23516.562399999999" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">23516.56 </td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" xnum="18875.84" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">18875.84 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" 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;">数控刀片</td><td class="xl26" xnum="201536.96" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">201536.96 </td><td class="xl27" xnum="247989.71503000002" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">247989.72 </td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" xnum="160115.58199999994" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">160115.58 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" 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;">库存总额</td><td class="xl26" xnum="699222.26" xfmla="=SUM(B2:B7)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">699222.26 </td><td class="xl26" xnum="814292.36963000009" xfmla="=SUM(C2:C7)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">814292.37 </td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">……</td><td class="xl26" xnum="710840.5639999999" xfmla="=SUM(E2:E7)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">710840.56 </td></tr></tbody></table><shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" coordsize="21600,21600" ospt="75" opreferrelative="t"></shapetype><stroke joinstyle="miter"></stroke><stroke></stroke><formulas></formulas><f eqn="if lineDrawn pixelLineWidth 0"></f><f></f><f eqn="sum @0 1 0"></f><f></f><f eqn="sum 0 0 @1"></f><f></f><f eqn="prod @2 1 2"></f><f></f><f eqn="prod @3 21600 pixelWidth"></f><f></f><f eqn="prod @3 21600 pixelHeight"></f><f></f><f eqn="sum @0 0 1"></f><f></f><f eqn="prod @6 1 2"></f><f></f><f eqn="prod @7 21600 pixelWidth"></f><f></f><f eqn="sum @8 21600 0"></f><f></f><f eqn="prod @7 21600 pixelHeight"></f><f></f><f eqn="sum @10 21600 0"></f><f></f><formulas></formulas><path gradientshapeok="t"></path><path></path><lock aspectratio="t" vext="edit"></lock><lock></lock><shapetype></shapetype>大家知道  这么多个选项，而且总额跟其它的差别比较大，如果直接作图的画，图表会显得很混乱，而且也看不出什么东西来  现在来教大家做个图表，制作出动态图表

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

[此贴子已经被作者于2008-5-20 23:27:07编辑过]

北部湾 · 发表于 2008-5-18 19:20

图表四：动态图表（二） 再讲一种　使用定义名称的方法来建立内存数据，以此作为数据源，实现动态图表

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

[此贴子已经被作者于2008-5-21 21:35:57编辑过]

北部湾 · 发表于 2008-5-18 19:20

图表五：用滚动条制作动态图表

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

[此贴子已经被作者于2008-5-21 21:38:01编辑过]

ZBKYOYO · 发表于 2008-5-18 19:27

来了

zhouyuping · 发表于 2008-5-18 19:30

来了，刚刚学什么都不太会，好害怕学不会呀！！！[em04]

情愫 · 发表于 2008-5-18 19:39

来了[em01]

xuepiao163 · 发表于 2008-5-18 19:41

来了

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