Quantcast

How-to Easily Make a Dynamic PivotTable Pie Chart for the Top X Values

I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5...

Step-by-Step Horizontal Bar Chart with Vertical Lines Tutorial

6
In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...

Friday Challenge – Analyzing Attendance Records with Charts and Trend Line

For this Friday Challenge, lets see if we can help this user with their data. Read it over, but really, the last line of the...
Quickest Way to Select and Align Charts for an Excel Dashboard Featured Image

Quickest Way to Select and Align Charts for an Excel Dashboard

Select and Align Charts for an Excel Dashboard Creating dashboards can take a lot of time.  With this simple technique that I just learned, you...

How-to Mimic a Newspaper Chart Line Style in Excel

In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart...

How-to Use Data Labels from a Range in an Excel Chart

Excel 2013 has some cool features. If you were not aware, here is an awesome Chart Data Label option that you now have when...

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

Merry Christmas from Excel Dashboard Templates

0
Hope you and your family and friends have a wonderful Christmas season. For the season, I have created a Christmas Wreath made from an Excel...
How-to Hide Pie Slices when Value Equals Zero

How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section

5
Okay, we have learned lots of different techniques to build our Company Executive Dashboard using Excel, and today I will give you a taste...

How-to Make a Dynamic Chart Using Offset Formula

1
In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables.  This is a very easy...
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