Friday Challenge Answer Part 1: Splitting Up Email Address Text
Hi All,
Here is the easy answer to the Friday Challenge on:
"How-to Split Up Email Address Text for First Middle Last Names"
Please check out the...
How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and...
Many times when you are building your Excel Dashboard Templates, you will want to hide rows or columns in the same area as your...
How-to Add Label Leader Lines to an Excel Pie Chart
This a an awesome technique to make your pie charts stand out in your Excel dashboard. However, I didn’t know about it for the...
3 Ways to Create Vertical Lines in an Excel Line Chart
Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish. We...
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 Create a Stacked Clustered Column Chart with 2 Axes
In response to another post of mine, EC wrote:
“My issue: This site has been really helpful so far! I have a follow up question....
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...
Problems Creating an Excel Open-High-Low-Close (Candle Stick) Stock Chart
Every time and I mean EVERY TIME that I go to create a Candle Stick Stock Chart in Excel (otherwise known as an Open-High-Low-Close...
How-to Insert Slicers into an Excel Pivot Table
In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart
we described the best way to configure your data to easily create your next dashboard.
In this post, we explore the...
How-to Make an Excel Project Status Spectrum Chart
Here is the long awaited demonstration of a recent Friday Challenge.
The challenge was to recreate a Project Management Status Chart that I saw on...
