Challenge
Friday Challenge – Allocation Formulas
Facebook Twitter Pinterest WhatsApp Linkedin Today I have 2 formula challenges that you may find interesting. They are both different types of allocation formulas. Challenge 1: Problem: You
EXPLORE THE LIBRARY
/category/excel/page/8/
Bar Chart
How-to Center Excel Clustered Chart Columns Over Horizontal Category Labels
When you have several series in one chart and only one of those series appear per Horizontal Label Category, you probably want to center the labels as the default will appear in their own se
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
Challenge
Don’s Macro Enabled Friday Challenge Answer – Music Festival Schedule Excel Chart
In our last Friday Challenge, we wanted to see if you can make a Music Festival Schedule in an Excel Chart. There were 2 questions. 1) Make a chart using Conditional Formatting and 2) Make
Bar Chart
Friday Challenge – Create a Chart to Display a Music Festival Schedule
Here is an interesting question that I saw and I thought I would present it as the next in the series of Friday Challenges. This is a similar problem that I ran into at a recent company. Th
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
Terrible Chart Tuesday – Leader Lines
So in yesterday’s post, I showed you that in Excel 2013, you can now add leader lines to your Line Chart. They are not just reserved for Pie Charts like in previous versions of Excel. But I