Quantcast

How-to Add a Shape to a PowerPoint Table and Make it Move and Size...

As a project manager or business analyst, we are often called upon to create dashboard type views in status reports for Executives. Typically, company executives...

How-to Make Dynamic Excel Dashboard Charts Using Tables

1
For almost every Excel Dashboard you will want to make a Chart template Dynamic.  Meaning that as you add new data, the chart updates...

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

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

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

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

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

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