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.
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#.
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.
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
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.
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.
The table above lists some internet Top Level Domains (TLD) and their equivalent country codes. How can we look up the country name from the table if we know its TLD? E.g. we have the code “cn” and we want to know the corresponding country name. We can achieve this by using the INDEX and MATCH functions to search for a specific TLD code and pick up the corresponding country name from the adjacent column, as follows.
Welcome to YouTube! The location filter shows you popular videos from the selected country or region on lists like Most Viewed and in search results.To change your location filter, please use the links in the footer at the bottom of the page. Click "OK" to accept this setting, or click "Cancel" to set your location filter to "Worldwide". The location filter shows you popular videos from the selected country or region on lists like Most Viewed and in search results. To change your country filter, please use the links in the footer at the bottom of the page.
Posted on December 8th, 2010 in Charts and Graphs , Pivot Tables & Charts - 25 comments Do you know that Excel 2010 makes creation of dynamic dashboards very simple? Yes, that is right. Using slicers feature, you can create dynamic excel dashboards from your data in very little time. Today we are going to learn a technique that will help you create a dashboard like below. (Note: The technique works only Excel 2010 or above.)