Filled Histograms Using Excel XY-Area Charts I recently showed how to create Histograms Using Excel XY Charts. This technique produces a human-friendly numerical X axis scale, which is easier to read and harder to be deceived by than the bin labels used by column chart histograms. The drawback of that technique is that it produces histogram bars in outline only, without a fill color. In this post I will show how to extend that technique to fill the bars, using the protocol from Fill Below an XY Chart Series with an XY-Area Combination Chart. I started with the data from Histograms Using Excel XY Charts. The calculated values in the middle column are based on the small table to the right. Area Value = Area Scale Min + (Time - Time Min) / (Time Max - Time Min) * (Area Scale Max - Area Scale Min) or something like this, depending on where the tables are in the worksheet: We need to use both XY and Area chart types. So let’s make the chart. Copy the Area and Counts in the second and third columns, including the first and last row.
WordRibbon.Tips.Net Excel Home论坛 Documentary Heaven | Watch Free Documentaries Online Excel Pivot Table Tutorial -- Running Totals With a running total in a pivot table, you can see how amounts accumulate over a period of time, or through a range of products. To create a running total, use the Custom Calculation feature in a pivot table. In this pivot table tutorial, we'll focus on the Running Total custom calculation. Video: Create Running Totals To show running totals, you'll u se the Custom Calculation feature in Excel's pivot tables, as shown in this video tutorial.
Ultimate Guide to Twitter Hashtags What is a Twitter hashtag? A hashtag is a way to unite global Tweets around some particular topic. Basically, these are tags that that help those who seek similar content discover your Tweets. According to the official source: Hashtags are a community-driven convention for adding additional context and metadata to your tweets. Hashtags are getting more and more popular (despite the fact some people are against them wishing their Twitter stream to be metadata-free and “as human a form of communication as possible”). Add more Twitter Followers using twitter location search Anyway, I do use hashtags and find them fun, so I am sharing a few tips and resources below. Where can I find what hashtags people are using? #hashtags.org is the first place to find most recent and hot hashtags. Twemes.com is another useful resource for discovering new hashtags and tracking those you are interested in. Wthashtag.com is a user generated wiki of hashtags. How are hashtags used? Do you use hashtags?
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. If you want something a little more complex than a simple color graphic, you could use a free program to map the data, such as Google Earth ( Step Up and Take Control! Comments for this tip: Frank Bowyer22 Jan 2013, 22:03 I spent sometime last year mapping data using Google's Fusion Tables. Bob Davey22 Jan 2013, 18:46
250+ Killer Digital Libraries and Archives Hundreds of libraries and archives exist online, from university-supported sites to accredited online schools to individual efforts. Each one has something to offer to researchers, students, and teachers. This list contains over 250 libraries and archives that focus mainly on localized, regional, and U.S. history, but it also includes larger collections, eText and eBook repositories, and a short list of directories to help you continue your research efforts. The sites listed here are mainly open access, which means that the digital formats are viewable and usable by the general public. Efforts were made to go to the root source for these collections. As a warning, many states listed their collections as “archives” when, in reality, the sources contained secondary sources such as books and transcriptions rather than a digital image of the actual document. Localized Collections The sites listed below focus on a certain state’s towns, cities, counties, or regions within a given state. Idaho
Disrupting Class: How Disruptive ... 图表事件应用范例汇总(共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 新增 )
14 Cool Photoshop Tutorial Websites to Become a Photoshop Master. Photoshop is an incredible software and for a creative mind it offers unlimited oppurtunities to express itself. However, given our time limitations , we are not always able to spend the time to learn the complex menus of this software. The best option is then to use some of the sites which provide great photoshop tutorials and learn exactly what one wants to .I am listing here 14 cool sites which should not be missed by photoshop lovers. 1.PSDtuts PSDTUTS is a blog/Photoshop site made to house and showcase some of the best Photoshop tutorials around. gives you very detailed illustrations with a large number of pictures.The tutorials are very long , but perhaps because they go in so much of minute details and the graphics are complex.The collection is quite good and I use them often. 2.Photoshop Website An aggregator ,this site has a great collection of photoshop tutorials and hundreds of photoshop brushes to download. 3.PS hero 4.You Suck at Photoshop 5.PSD Learning 6.Photoshop Tutorials
The Whiteboard Blog 开始使用Office 2013啦 | 完美Excel