Excel
Get flash to fully experience Pearltrees
The capabilities of Microsoft Excel are astounding, and it always seems there is something new to learn that will help you tweek your data in new and exciting ways. Because Excel can do so much, it helps to discover what others are doing with the program and get real, "hands-on" information about things you can do. That's where ExcelRibbon.Tips.Net comes into play. The tips and ideas you find here are designed specifically for users of Excel starting with Excel 2007.
ExcelRibbon.Tips.Net - Powerful tips on using Microsoft Excel
*Microsoft Excel MVP Jon Peltier is a metallurgical engineer, with 23 years experience in Research and Development. His academic credentials include a Doctor of Science in Metallurgy, with a minor program in Statistics. Jon was Technical Editor for Excel Charts , and he has an extensive web site, with an emphasis on Excel charts and Excel chart utilities .
Jon Peltier's Web Site -- Excel Chart Index
Filled Histograms Using Excel XY-Area Charts | Peltier Tech Blog | Excel 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 .
The Excel Charts Blog — Charts, Dashboards and Effective Data Visualization for Excel Users
Welcome to the place where you can learn best practices for effective Excel charts in a corporate environment. In other words, where Tufte meets Excel . Learn how to get the most out of your data.
Note: If you select a base field that isn’t in the row or column area, all the results will show an #N/A error. Also, if there’s an error in any month’s results, it will carry down through the remaining months. You can now see that there were 621 units of the A703 product sold by the end of February.