How-to Recreate a NYT InfoGraphic Mustache Grouping Chart in Excel
I love trying to create an Excel chart that was originally drawn with an Infographic software package. Back in 2011 I saw a New York...
How-to Quickly Get Excel Function Help Plus a Bonus Tip
In a recent post, I was exploring Excel AverageIF and other Average functions and I realized that I don’t know that much about the...
How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps
Project Managers and Executives love Gantt Charts. They also love Microsoft Excel, Charts and Graphs. So it is a natural to consider how you...
How-to Fake an Excel Chart Data Table
Fake an Excel Chart Data Table
Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...
How-to Convert an Existing Excel Data Set to a Pivot Table Format
In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...
How-to Line Up Your Excel Worksheet Embedded Charts
Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up?
Notice how the...
How-to Draw a Straight Line with Excel Shapes
Have you ever tried to draw a straight line in Excel only to get frustrated?
It can be so Frustrating :) to be off by...
How-to Make a WSJ Excel Pie Chart with Labels Both Inside and Outside
I thought it was a in last week’s USA Today, but looking at the picture I took more closely, it may have been produced...
Copy Paste vs Fill Handle Copy with Tables References in an Excel formula
In this recent post:
Friday Challenge Answers – Cumulative Events Over Time
I created a formula that referenced a table. As I created my video I...
How-to Find a Wild Card or Question Mark or Asterisk or Tilde in Excel
Lots of users use Excel for lists or you may receive reports from other people or systems and sometimes those files contain Wild Cards...
