Chart
How-to Create a Combo Line and Column Pivot Chart
Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts. I recently saw a post asking for this help: “Please advise if it is possible to combine a pivot line graph a
EXPLORE THE LIBRARY
/category/video-tutorial/page/6/
How-To
Excel Pranks: Non-VBA Edition 1
We should have some fun as it is the start of a long weekend and the end of summer. So what better way to have fun than with some pranks. And better yet, Excel Pranks. I saw a great thread
Bar Chart
Create a Excel Gantt Chart to Display a Music Festival Band Schedule
Facebook Twitter Pinterest WhatsApp Linkedin Here is Pete’s answer to the recent Music Festival Schedule Challenge. In this video, see how he used Index/Match functions as well as a helper r
Conditional Chart
How-to Make a Music Festival Schedule Using Excel Conditional Formatting
Recently, I saw an Excel User posting a question about how to make this Music Festival Schedule using Excel Charts. However, he originally created the schedule in the worksheet area using ce
Chart
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 a chart”. Here is the basis of the question at hand: “I’m not su
Chart
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 values. The user had to create this pie chart regularly from a larger data set and
Formatting
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 is pretty simple to display in Excel but only if you know how Excel treats tim
Chart
New Chart Label Leader Lines Available in Excel 2013
Did you know that you can now add Leader Lines to your Excel Charts in Excel 2013? I didn’t know this until just recently. I never thought to look. I always thought that they were only ava
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
Chart
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,