改进(Excel)图表的10×10个贴士.docVIP

改进（Excel）图表的10×10个贴士（转贴＋翻译） 2009-09-02 【向阳花:www.716.cc-萤火虫儿】 【纠错】 【点击: 78次】 　　最近重读了Jorge写的改进图表的系列帖子，经联系作者同意，转贴在这里，并简单做了些翻译(要点意译，非正式翻译)。 　　This is the first in a series of 10 posts where I’ll suggest a (hopefully) coherent set of tips to improve our charts and, more important, to improve the way we make sense of the data. These are the planned posts: 　　1. General charting; 　　2. Formating; 　　3. Column/Bar charts; 　　4. Line charts; 　　5. Scatterplots (XY charts); 　　6. Pie charts; 　　7. Other chart formats; 　　8. Dynamic charts; 　　9. Dashboards; 　　10. Miscellaneous tips; 　　11. Bonus post: online resources. 　　These will be very short tips, and I’m sure some of them will require further explanation. In time, all of them will be properly linked to a more detailed post (that will keep me off the streets for a while…). This is a kind of road map for the next few months and, when finished, a (partial) table of contents for the blog. ? 　　1、通用类： 　　/10-x-10-tips-to-improve-your-excel-charts-general-tips/ 　　So, general tips on charting: 　　1. A chart shows trends, patterns, outliers; if you already strive to make them apparent, you don’t need to read the next 99 tips…; 　　图表应反映趋势、关系/模式、异常 　　2. Do you really need a chart? Sometimes the task and the data suggest another method of data analysis; 　　是否真的需要图表? 　　3. Know your audience. If your audience is uncomfortable with some formats your message will be lost; 　　了解你的听众 　　4. Make sure you have enough data to create a pattern (two data points are not enough to create a trend line); 　　要有足够的数据～～有的人对只有3、5个点的序列做趋势预测 　　5. Make sure you don’t have more than enough data: just because you have it, you don’t have to show it…; keep removing interesting data until only relevant data for your problem remains; 　　不要过多的数据～～过多细节淹没信息 　　6. A chart should be able to answer elementary, intermediate and global questions regarding the data; 　　图表应能回答问题 　　7. Don’t assume that the charts you see in the media are the ones you need to run your business; 　　你在媒体上看到的图表