开始使用Office 2013啦 | 完美Excel. 图表事件应用范例汇总(共40+例Chartevents)-Excel图表与图形-ExcelHome技术论坛 - 本帖最后由 single_star 于 2013-3-26 10:33 编辑 可设定双断轴的自定义刻度截断图 (Chart2-9,2012/2/29新增） 散点图数据标签自动标示对应名称 汽泡图数据标签自动标示对应名称 汽泡图数据标签自动标示对应名称及颜色 (可筛选并设定数据点汽泡显示固定颜色) chart2&chart1的结合应用(图文并茂的数据标签) 点数据点显示对应内容数据标签的散点图 (Chart2-3,2012/2/14新增) 自定义文字X轴的散点图(依单元格底色及字形设定X轴文字格式) (Chart2-5-2,2011/11/2更新增加粗体及背景颜色等字型设定) 散点图数据标签自动标示对应名称2 (灵活的散点图数据标签,点选数据点会显示详细内容；来源资料筛选后也可自动正常显示) 另类截断图,超出管制线的点会自动变色！。。 各分层可设不同背景色的 另类截断图 (Chart2-8,2012/2/24新增) 适合数据差异大的双轴柱状图+折线图的另类截断图 (分层图,Chart2-8-2,2012/3/13新增) 点选图例或数据列即可单独放大显示对应数据列的多Y轴图(点选其他处则回复全部，autoscale3,2012/7/24 新增 )
Excel精英培训. Excel Home论坛. Excel Excel图表可以很强大——气泡图和散点图的“叠加”-Excel图表与图形-Excel Home论坛 - ExcelTips. Graphically Charting Geographic Data (Microsoft Excel) Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Graphically Charting Geographic Data. Kauai has students from all over the country enrolled in classes at his school. He would like to build a graphical chart of the US states, charting school enrollments by state and color code the states based on the number of enrollments from that state.
Excel doesn't provide a way for you to do this, within the Excel program itself. Instead you'll need to get an additional program, such as Microsoft MapPoint ( or SPSS ( (Creating the desired map with SPSS is very easy to do.) Step Up and Take Control! Comments for this tip: Frank Bowyer22 Jan 2013, 22:03 Bob Davey22 Jan 2013, 18:46 Glenn22 Jan 2013, 16:38. ExcelPro的图表博客-我的搜狐. 《用地图说话》链接. Mail from Excel example pages.