4.2 不等宽条形图做法 3度量.xls

分析数据：wsj的做法： 普通做法： 体验地址： /article/sb122584499389399483.html#articletabs_interactive%26articletabs%3dinteractive excelpro的的图图表表博博客客 excelp 66% 66% 54% 49% 50% 45% 32% 31% 44% 49% 49% 53% 1824 2529 3039 4049 5064 65 obamamccain 1,57,91127,1,31 0,76,127183,0,35 2,102,177 234,26,59 76,128,193240,123,109 137,165,213245,158,145 184,199,229248,189,173 232,232,232 /article/sb122584499389399483.html#articletabs_interactive%26articletabs%3dinteractive excelpro的的图图表表博博客客 excelp of votersobamammccain 182410%66%2%32% 25298%66%3%31% 303918%54%2%44% 404921%49%2%49% 506426%50%1%49% 6517%45%2%53% excelpro的的图图表表博博客客 excelp 66% 66% 54% 49% 50% 45% 32% 31% 44% 49% 49% 53% 1824 2529 3039 4049 5064 65 obamamccain excelpro的的图图表表博博客客 excelp 用细分条形图做不等框条形图excelpro的的图图表表博博客客 excelp 原始数据： of votersobamammccain 18-2410%66%2%32%18-24 ( 10% ) 10% 25-298%66%3%31%25-29 ( 8% ) 18% 30-3918%54%2%44%30-39 ( 18% ) 36% 40-4921%49%2%49%40-49 ( 21% ) 57% 50-6426%50%1%49%50-64 ( 26% ) 83% 65+ 17%45%2%53%65+ ( 17% ) 100% 5%-0.1 14%-0.1 27%-0.1 47%-0.1 70%-0.1 92%-0.1 obamamccain 1824252930394049 0%10%18%36% 10%18%36%57% 66%2%32%66%3%31%54%2%44%49% 作图数据区： 1%66%2%32% 2%66%2%32% 3%66%2%32% 4%66%2%32% 5%66%2%32% 6%66%2%32% 7%66%2%32% 8%66%2%32% 33%84%9%66%2%32% 33%85%10%66%2%32% 27%78% 25%76%11%66%3%31% 25%76%12%66%3%31% 23%74%13%66%3%31% 14%66%3%31% 15%66%3%31% 16%66%3%31% 17%66%3%31% 18%66%3%31% 19%54%2%44% 20%54%2%44% 21%54%2%44% 22%54%2%44% 23%54%2%44% 24%54%2%44% 25%54%2%44% 26%54%2%44% 27%54%2%44% 28%54%2%44% 29%54%2%44% 30%54%2%44% 31%54%2%44% 32%54%2%44% 33%54%2%44% 34%54%2%44% 35%54%2%44% 36%54%2%44% 37%49% 38%49% 39%49% 40%49% 41%49% 42%49% 43%49% 44%49% 45%49% 46%49% 47%49% 48%49% 49%49% 50%49% 51%49% 52%49% 53%49% 54%49% 55%49% 56%49% 57%49% 58% 59% 60% 61% 62% 63% 64% 65% 66% 67% 68% 69% 70% 71% 72% 73% 74% 75% 76% 77% 78% 79% 80% 81% 82% 83% 84% 85% 86% 87% 88% 89% 90% 91% 92% 93% 94% 95% 96% 97% 98% 99% 100% 506465 57%83%obama 83%100% 2%49%50%1%49%45%2%53%step by step: 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 1 2 3 4 5 6 7 8 9 10 150%100%50%0% series1 series2 series3 1 14 27 40 53 66 79 92 105 150%100%50%0% series1 series2 series3 series4 series5 series6 series7 series8 series9 series10 series11 series12 series13 series14 series15 series16 series17 series18 1 14 27 40 53 66 79 92 105 150%100%50%0%series1 series2 series3 series4 series5 series6 series7 series8 series9 series10 series11 series12 series13 series14 series15 series16 series17 series18 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 2%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% mccain 用左上角部分作图 扩展数据源至整个数据区 反转分类次序 设置所有序列无框，按例图填色 加入数据标签、坐标轴标签 1 2 3 4 5 6 7 8 9 10 150%100%50%0% series1 series2 series3 1 14 27 40 53 66 79 92 105 150%100%50%0% series1 series2 series3 series4 series5 series6 series7 series8 series9 series10 series11 series12 series13 series14 series15 series16 series17 series18 1 14 27 40 53 66 79 92 105 150%100%50%0%series1 series2 series3 series4 series5 series6 series7 series8 series9 series10 series11 series12 series13 series14 series15 series16 series17 series18 of votersobamammccain 182410%66%2%32%10%1% 25298%66%3%31%18%2% 303918%54%2%44%36%3% 404921%49%2%49%57%4% 506426%50%1%49%83%5% 6517%45%2%53%100%6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 26% 27% 28% 29% 30% 31% 32% 33% 34% 35% 36% 37% 38% 39% 40% 41% 42% 43% 44% 45% 46% 47% 48% 49% 50% 51% 52% 53% 54% 55% 56% 57% 58% 59% 60% 61% 62% 63% 64% 65% 66% 67% 68% 69% 70% 71% 72% 73% 74% 75% 76% 77% 78% 79% 80% 81% 82% 83% 84% 85% 86% 87% 88% 89% 90% 91% 92% 93% 94% 95% 96% 97% 98% 99% 100% obamamccain 66%2%32% 66%2%32% 66%2%32% 66%2%32% 66%2%32% 66%2%32% 66%2%32% 66%2%32% 66%2%32% 66%2%32% 66%3%31% 66%3%31% 66%3%31% 66%3%31% 66%3%31% 66%3%31% 66%3%31% 66%3%31% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 54%2%44% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 49%2%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 50%1%49% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 45%2%53% 用时间刻度的堆积面积图作不等宽条形图excelpro的的图图表表博博客客 excelp 原始数据： of votersobamammccain 18-2410%66%2%32%18-24 ( 10% ) 10% 25-29 8%66%3%31%25-29 ( 8% ) 18% 30-3918%54%2%44%30-39 ( 18% ) 36% 40-4921%49%2%49%40-49 ( 21% ) 57% 50-6426%50%1%49%50-64 ( 26% ) 83% 65+ 17%45%2%53%65+ ( 17% ) 100% 标签位置： 0-0.20.2 10-0.20.2 18-0.20.2 36-0.20.2 57-0.20.2 83-0.20.2 手动标签： 辅助序列标签： 66% 32% 66%31% 54%44% 49%49% 50%49% 45%53% obama mccain 18-24 ( 10% ) 25-29 ( 8% ) 30-39 ( 18% ) 40-49 ( 21% ) 50-64 ( 26% ) 65+ ( 17% ) 66% 66% 54% 49% 50% 45% 32% 31% 44% 49% 49% 53% 18-24 ( 10% ) 25-29 ( 8% ) 30-39 ( 18% ) 40-49 ( 21% ) 50-64 ( 26% ) 65+ ( 17% ) obama mccain 66% 66% 54% 49% 50% 45% 53% 49% 49% 44% 31% 32% 65+ ( 17% ) 50-64 ( 26% ) 40-49 ( 21% ) 30-39 ( 18% ) 25-29 ( 8% ) 18-24 ( 10% ) 66% 32% 66%31% 54%44% 49%49% 50%49% 45%53% 25-29 ( 8% ) 18-2425-29 30-3940-4950-6465+ 0% 20% 40% 60% 80% 100% mccain m obama 66% 66% 54% 49% 50% 45% 32% 31% 44% 49% 49% 53% 18-24 ( 10% ) 25-29 ( 8% ) 30-39 ( 18% ) 40-49 ( 21% ) 50-64 ( 26% ) 65+ ( 17% ) obama mccain 66% 66% 54% 49% 50% 45% 53% 49% 49% 44% 31% 32% 65+ ( 17% ) 50-64 ( 26% ) 40-49 ( 21% ) 30-39 ( 18% ) 25-29 ( 8% ) 18-24 ( 10% ) 作图数据区： 066%2%32% 1066%2%32% 100%0%0% 1066%3%31% 1866%3%31% 180%0%0% 1854%2%44% 3654%2%44% 0.9360%0%0% 0.93649% 0.95749% 0.9570% 0.957 0.983 83 83 100 excelpro的的图图表表博博客客 excelp 66% 66% 54% 49% 50% 45% 53% 49% 49% 44% 31% 32% 65+ ( 17% ) 50-64 ( 26% ) 40-49 ( 21% ) 30-39 ( 18% ) 25-29 ( 8% ) 18-24 ( 10% ) 66% 32% 66%31% 54%44% 49%49% 50%49% 45%53% 25-29 ( 8% ) 66% 66% 54% 49% 50% 45% 53% 49% 49% 44% 31% 32% 65+ ( 17% ) 50-64 ( 26% ) 40-49 ( 21% ) 30-39 ( 18% ) 25-29 ( 8% ) 18-24 ( 10% ) obamamccain step by step: 2%49% 2%49% 0%0% 50%1%49% 50%1%49% 0%0%0% 45%2%53% 45%2%53% 1 2 3 4 5 6 7 8 9 1011121314151617 0% 20% 40% 60% 80% 100% 120%series19 series18 series17 series16 series15 series14 series13 series12 series11 series10 series9 series8 series7 series6 series5 series4 series3 series2 12/31/189 9 1/14/1900 1/28/1900 2/11/1900 2/25/1900 3/11/1900 3/25/1900 4/8/1900 0% 20% 40% 60% 80% 100% 120% 做堆积面积图 设置x轴为时间刻度 设置分类轴标签为m6：m22 其他格式化至例图效果。填色，白框 1 2 3 4 5 6 7 8 9 1011121314151617 0% 20% 40% 60% 80% 100% 120%series19 series18 series17 series16 series15 series14 series13 series12 series11 series10 series9 series8 series7 series6 series5 series4 series3 series2 12/31/189 9 1/14/1900 1/28/1900 2/11/1900 2/25/1900 3/11/1900 3/25/1900 4/8/1900 0% 20% 40% 60% 80% 100% 120% 使用条款 copyright (c) 2010 by excelpro的图表博客 http:/excelp 本使用条款不得被修改、删除。 all rights are reserved. this workbook may not be reprinted or distributed in electronic, print, web, or other format without express written permission from the author. this workbook is designed to provide information about microsoft excel. every effort has been made to make them as complete and accurate as possible. the information is provided on an “as is” basis. the author and excelp shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the contents or use of these workbooks. you may make archival copies and customize this template (the “software“) for personal use or for your company use. the customized template (with your specific personal or company information) may be used and shared within your company, but this template or any document including or derived from this template may not be sold, distributed, or placed on a public server such as the internet. caution: this spreadsheet is for educational and illustrative purposes only and should not be construed as financial advice. the results may not reflect reality and may not apply to your specific situation. 本文档作为excel图表之道一书的配套范例文件而建立，仅作为该书读者个人对照书本阅读、理解、学习之用途，不得用 于转让、出售、商业培训等任何营利性质的用途，也不得发布到互联网上任何网站、论坛、社区、博客等途径提供免费或收费下载 。 all rights are reserved. this workbook may not be reprinted or distributed in electronic, print, web, or other format without express written permission from the author. this workbook is designed to provide information about microsoft excel. every effort has been made to make them as complete and accurate as possibl