Quantcast

Friday Challenge – Analyzing Attendance Records with Six Sigma Charts

The following is a guest post from Pete on his answer to the most recent Friday Challenge. Pete applied his knowledge of Six Sigma to...

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 Add a Line to an Excel Chart Data Table and Not to the...

8
Many people making Excel charts love to add a Chart Data Table to their graph.  However, the Excel Data Tables are not very flexible...

How-to Create and Copy a Table in Google Mail (Gmail) from Excel

30
On a recent project of mine, I tasked a team member with creating a communication to send out to users.  This communication involved making...

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 Make a Dynamic Excel Pie Chart with 4 steps in less than 4...

This is an awesome guest post from our great friend Pete.  He came up with this awesome technique to make a dynamic pie chart...

How-to Create a Dynamic Excel Pivot Table Dashboard Chart

In my last 2 posts: I showed you how to setup your data in preparation for creating a dynamic dashboard chart Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart And then I...

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 Show Text in an Excel Chart Data Table (Part 1)

Yesterday, I showed you how you can use the new label options in Excel 2013 to help Kevin with his engineering chart.  But we...

The Tricks to Writing a Conditional Formatting Rule Formula

0
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link