EXCEL图表 bullet图 误差线做法.xlsVIP

使用条款 Sheet3 Sheet2 Sheet1 valuevx 42.31 实际 目标 一般 良好 优秀 KPI 1 KPI 2 KPI 3 KPI 4 KPI 5 y Step by step: bullet图，水平，做法2 将实际、目标序列的图表类型改为散点图 此时数据源不对，暂不管 为目标序列贴入小竖线 其他格式化 http://ExcelP 2009.9.3 用C-G列做堆积条形图 先做一些格式化，设置3个区间的填充色 反转分类x轴的次序 指定实际、目标序列的x、y值，x为原数据，y为I列 设置实际序列的X误差线，为实际序列 在2003中，误差线的线型只有3种，选最粗的 在2007中，误差线可设置为任意粗的线型，因此可以做到bullet的效果 所以此做法在2007中应该是很好的，不要尾部的点 ExcelPro的图表博客 2007中的误差线可以设置线型磅数 因此可以完全达到bullet图的样式 2007则可设置到如此效果 使用条款 本使用条款不得被修改、删除。 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. 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 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. Copyright (c) 2010 by ExcelPro的图表博客 http://ExcelP 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 this template may NOT be sold, distributed, or placed on a public server such as the internet. 本文档作为《Excel图表之道》一书的配套范例文件而建立，仅作为该书读者个人对照书本阅读、理解、学习之用途，不得用于转让、出售、商业培训等任何营利性质的用途，也不得发布到互联网上任何网站、论坛、社区、博客等途径提供免费或收费下载。 本文档仅作为该书案例讲解和读者学习理解之用途，已尽量设计得正确。但若读者将其用于公司内部实际工作使用，本文档并不保证适合所有的应用场景，无论读者是否进行定制化修改，本作者对由此所可能引起的任何错误、损失等不承担任何责任。 1.10 .95 .70 .15 .15 4.50 .94 .90 .70 .15 .15 3.50 .97 .90 .70 .15 .15 2.50 .78 .90 .70 .15 .15 1.50 .68