《4.2 Mekko 产品组合市场份额》.xls

使用条款 1 valuevx 42.31 公司A 公司B 公司C 细分1 细分1 细分2 细分3 原始数据： 用填色区域做堆积面积图 设置x轴为时间刻度 x轴分类标志为J列 其他格式化 1.简单做法： 2.如果想分开填色的做法： 用框内数据做堆积面积图 其他步骤均同方法1 细分市场份额矩阵图 Step by step： 因事先顺序没有调好，调整序列的顺序，使图更清晰 数据组织： 手动添加标签，略 注意我提前做了优化排序 ExcelPro的图表博客 使用条款 本使用条款不得被修改、删除。 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 细分3 细分2 .00 .05 .90 .05 .05 .05 .90 .05 .10 .80 25.00 100.00 .05 .90 .05 .05 .05 .90 .90 .80 .05 25.00 .00 .00 .00 .00 .00 .00 .05 .10 .15 25.00 .10 .80 .10 .10 .10 .80 .25 .10 .65 35.00 100.00 .10 .80 .10 .10 .10 .80 .25 .35 1.00 35.00 .00 .00 .00 .00 .00 .00 35.00 .80 .05 .15 .80 .15 .05 100.00