ms excel
Get flash to fully experience Pearltrees
Simple, powerful, and easy to customize, Excel macros can save you time and increase your productivity. Macros called loops are especially useful for working with ranges of data. Whether you've only heard about macros or already used them in Excel, now's the time to find out more about them.
Get in the loop with Excel macros - Training
Excel Experts E-Letter Archives
The Excel Experts E-Letter (or EEE) is a newsletter produced by David Hager. EEE is filled with useful tips and tricks for Excel. Most of the material in geared towards the more advanced user. Note: The EEE newsletter is no longer distributed via email. Any future issues will appear here. I'm pleased that David has agreed to make the past issues available from The Spreadsheet Page.
Welcome This web site is brought to you as a public service by Chip Pearson and Pearson Software Consulting, LLC . We provide complete consulting and custom application design and development for Excel, Office, Visual Basic, and the NET Framework in VB.NET and C#.
Pearson Software Consulting, LLC, Comprehensive Excel Information
The Problem In a comment to another post, a reader asked about fixing the series names in his charts. Apparently he has been given dozens of charts, and all the series are named Series1, Series2, etc., the default names you see if names have not been defined.
Peltier Tech Blog
Excel Charts Blog
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. Learn how to analyze and visually communicate quantitative information.Introduction Spark lines is this really cool way to visualize information. They are small high resolution line charts that show you where things are heading. Note that they don't show any detailed data, but only the general trend. This article explains how to create and use spark lines in your ASP.NET application. Using the code
SparkLines
Eugene's Blog: How To...Draw a Polar Diagram in Excel
I have added a new video to YouTube as part of my " How To... " series. This one is about drawing Polar Diagrams in Microsoft Excel. I teach about Polar Diagrams as part of the subject of Performance Measurement. They are really useful and easy to draw - they can graphically show gaps in performance without the detail of figures. It took me a few hours to create this video - I made so many mistakes that I had to re-record it several times. I used PowerPoint to record the audio and Audacity to edit the .WAV files.
How to Make a Donut-Pie Combination Chart
We’ve been dissing pie charts and donut charts quite a bit. So why then would we want a donut-pie combination chart? In Jorge Camoes’ How to create better pie charts , he showed a chart like this one. It’s not so much a pie chart as it is a donut chart with about 40 series, the inner 30 sharing the same data, so they seem to make a single wedge.
By: Jeff Clark Date: Thu, 27 Jul 2006 I promised a few months ago to describe something I call a Multi-level Pie Chart or Radial Treemap. I spent some time developing the idea as an alternative to the standard Treemap a few years ago before discovering that it had been done before . Despite the fact the idea has been around since 2000 it seems to be little known. I will illustrate the concept using survival data for the people on board the RMS Titanic which sank in 1912.
Multi-level Pie Charts
