Extract Text From String With Known Position
You may need to get a part of a text string from within another text string. If you know starting position of the text you...
Author: melih
Import Text Files Into Excel
Once in a while you may encounter data in a text form. If you copy this data and paste it directly to Excel, all columns...
Dynamic Chart with Offset Function
In this post, I will show you how to create dynamic charts with Offset Function. You can create super handsome charts once you get a...
Butterfly Chart
Butterfly chart is a very nice visualization technique for comparing two data series side by side. You can easily see how one series do compared...
Interactive Donut Chart
While surfing the net, I saw a nice interactive donut chart with an equally nice data table beside it. I wondered whether I can do...
WSJ Everest Chart
This is the first post of a new series I call “Do It in Excel”. I will be recreating data visualizations of several sources in...
