Beat Excel! Get to next level in Excel!

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...

Centered Stacked Bar Chart

If you need to compare 2 data series, stacked bar chart might be just what you need. You can of course insert a stack bar...