请教：九宫折线图或多系列数据的呈现方法

hjshan · 发表于 2009-6-14 10:58

我《EXCEL HOME 图表实战技巧》的光盘找不到了，九宫折线图的那些散点图坐标和仿轴的辅助数据怎么做呀：）

能给传分电子版的吗？邮箱：lizigeng00@126.com

或者请教一下计算公式？

[ 本帖最后由 hjshan 于 2009-6-14 11:51 编辑 ]

hjshan · 发表于 2009-6-14 11:50

补充一下数据，每行的合计为100％：
不好意思，横轴和纵轴不好写实际的内容
帮看一下，用什么类型的图表显示比较好，目前想到的是九宫折线图，但做不出来

人员类别一类别二类别三类别四类别五类别六类别七类别八类别九类别十整体情况
1 48% 29% 17% 24% 17% 7% 2% 1% 2% 0% 51%
2 53% 28% 16% 30% 10% 8% 1% 2% 7% 0% 20%
3 49% 33% 17% 46% 2% 11% 2% 2% 0% 0% 15%
4 34% 36% 49% 7% 15% 2% 2% 0% 0% 0% 12%
5 43% 28% 25% 18% 7% 8% 2% 0% 0% 2% 11%
6 66% 43% 17% 6% 11% 3% 6% 3% 0% 0% 8%
7 58% 30% 24% 33% 3% 0% 0% 3% 0% 0% 7%
8 32% 32% 47% 21% 5% 11% 5% 5% 5% 0% 4%
9 20% 20% 33% 13% 0% 7% 20% 27% 0% 7% 3%
10 38% 31% 44% 19% 6% 0% 0% 0% 0% 0% 3%
11 42% 42% 33% 17% 0% 8% 17% 0% 0% 0% 3%
12 14% 43% 29% 14% 29% 0% 29% 29% 14% 0% 2%
13 63% 38% 25% 0% 13% 0% 0% 0% 0% 0% 2%
14 14% 14% 71% 0% 0% 0% 29% 14% 0% 0% 1%
15 40% 20% 60% 0% 0% 20% 0% 0% 0% 0% 1%
16 0% 33% 33% 33% 0% 67% 67% 0% 0% 0% 1%
17 43% 29% 14% 14% 0% 0% 0% 0% 0% 0% 1%
18 50% 25% 50% 50% 0% 0% 0% 0% 0% 0% 1%
19 0% 100% 100% 0% 0% 0% 0% 0% 0% 0% 0%
20 50% 0% 0% 50% 0% 0% 0% 0% 0% 0% 0%
21 0% 0% 100% 0% 0% 0% 0% 0% 0% 0% 0%
22 0% 0% 0% 100% 0% 0% 0% 0% 0% 0% 0%
23 0% 0% 100% 0% 0% 0% 0% 0% 0% 0% 0%
24 80% 60% 0% 0% 0% 0% 0% 0% 0% 0% 1%
Total 46% 31% 24% 23% 11% 6% 3% 2% 2% 0% 149%

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