XLS《直条图》

直条图 "第一季高级房车销售量",,

,,

,,

,,

"厂牌","一月","二月","三月","总计" "福特",1215,985,753,2953 "宾士",983,745,1250,2978 "裕隆",1536,962,1123,3621 "三菱",756,569,628,1953 折线图 "台北","台中","高雄" "第一季",384,542,652 "第二季",532,345,456 "第三季",643,337,333 "第四季",264,123,234 圆形图 "学生居住地", "北部",14 "中部",10 "南部",8 "东部",4 "外岛",2 横条图 "全校人数", "一年级",50 "二年级",65 "三年级",98 "四年级",65 "五年级",110 "六年级",70 区域图 "台湾新生儿人口统计",,

,,

,2009,2010,2011,2012 "北部",1032,1976,1765,1432 "中部",2352,1890,1689,1453 "南部",1234,1100,980,700 "东部",123,100,80,58 "外岛",80,76,56,45 散布图 "月份","温度","冷饮","热饮" "1月",13,324,3765 "2月",15,534,3215 "3月",18,651,2789 "4月",26,1275,2543 "5月",28,2534,1345 "6月",30,2864,543 "7月",32,3245,418 "8月",35,3678,215 环圈图 "联成电脑学员年龄",,

, ,2009,2010,2011,2012 "20以下",2355,2561,2789,2956 "20~30",3426,3920,2987,3908 "30~40",1894,1900,1243,1690 "40~50",678,876,943,980 "50以上",45,56,78,86 泡泡图 "冰箱销售情况",,

"数量","金额","广告费(万)" 500,10000,800 1800,5000,200 2000,3500,600 1500,7000,400 800,2000,500 1000,4000,300 雷达图 "甲","乙","丙","丁" "国文",80,78,60,70 "英文",60,40,90,50 "数学",55,60,54,20 "自然",95,65,60,30 "社会",90,95,80,56

1 2

3 4

5 组头 大头目 小弟A 小弟B 二头目 小弟C 三头目