Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
楼主: jh_richey

[待分类] [分享]特殊统计

  [复制链接]
发表于 2008-11-23 12:18 | 显示全部楼层

l
回复

使用道具 举报

发表于 2008-11-23 13:52 | 显示全部楼层
回复

使用道具 举报

发表于 2008-11-23 16:37 | 显示全部楼层

<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> </span></div><div style="mso-line-spacing: '100 50 0'; mso-char-wrap: 1; mso-kinsoku-overflow: 1;"><span lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">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 lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">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 lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">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 lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">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 lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">4</span><span style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial;">,在</span><span lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">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 lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">5</span><span style="FONT-FAMILY: 宋体; mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial;">,在</span><span lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">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 lang="EN-US" style="mso-fareast-font-family: 宋体; mso-hansi-font-family: Arial; mso-fareast-language: ZH-CN;">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> </span></div>
回复

使用道具 举报

发表于 2008-11-23 16:43 | 显示全部楼层

谢谢分享
回复

使用道具 举报

发表于 2008-11-28 15:58 | 显示全部楼层

ok
回复

使用道具 举报

发表于 2008-11-28 16:47 | 显示全部楼层

good
回复

使用道具 举报

发表于 2008-11-28 16:49 | 显示全部楼层

<p>看下</p>
回复

使用道具 举报

发表于 2008-11-28 20:15 | 显示全部楼层

回复:(jh_richey)[分享]特殊统计

xuexi
回复

使用道具 举报

发表于 2008-11-28 23:06 | 显示全部楼层

<p>学习</p>
回复

使用道具 举报

发表于 2008-11-28 23:49 | 显示全部楼层

谢谢分享.
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2025-8-16 14:07 , Processed in 0.511711 second(s), 4 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表