Home Tags How-to

Tag: How-to

How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart

Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...

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

How-to Display Military Time in an Excel Spreadsheet

A few days ago, I had a user ask me a question on the blog about how she can display military time in Excel. It...

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



Think Like a Database Designer Before Creating an Excel Dashboard Chart

Recently, a fan asked for some help.  However, when I got their file, I saw that they needed some help with basic concepts, so...

Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution

Hands off to Leonid :) for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart   Here was...

How-to Quickly Find and Jump to the Right Worksheet Tab in Your Excel Workbook

As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook.  However, if you create...

How-to Create a Time Data Series Step Chart in Excel

In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...



Petes Stumped Chart Challenge Answer – Pivot Chart with Slicers

In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set.  They...

Popular Posts

How-to Easily Create a Stacked Clustered Column Chart in Excel

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
We Know You Better!
Subscribe To Our Newsletter
Be the first to get latest updates and
exclusive content straight to your email inbox.
Yes, I want to receive updates
No Thanks!
close-link
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

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