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

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

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

Friday Challenge Solution – Excel 2013 Data Labels on a Range

In our last Friday Challenge, Friday Challenge – Showing More Categories in an Excel Chart we were trying to help Kevin with his problem.He had followed...



Friday Challenge – Showing More Categories in an Excel Chart

Can you help Kevin with his problem?Kevin saw this article: How-to Add a Line to an Excel Chart Data Table and Not to the Excel...

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

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

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

Case Study – Creating a Dynamic Chart in Excel Using Offset Formula

A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...



The Tricks to Writing a Conditional Formatting Rule Formula

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