Change Chart from Amount to Percent using a Drop Down List
In case you were wondering, here is my solution to last Friday’s Excel Challenge.
Our challenge was to see if we could solve this question...
Friday Challenge – Pipeline Usage Chart
I recently got a request from a subscriber that asked if I could help them create a cylinder chart. However the sample that was...
Why Won’t My Excel SumIFs Formula Work?!
Part of my time this week was spent working on a project for a client and I was sooo frustrated. I just couldn't get...
New Feature Excel Flash Fill Use it for Quick Data Retrieval and Formatting
Excel Flash Fill
Every time a new version of Excel is released there are always new features that are hard to find and learn for those...
Excel Line Charts Using a Date Axis
Not sure if you knew this or not, but Excel is amazing!
The makers of Microsoft Excel even went so far as to make sure...
Friday Challenge: Excel Step Chart Automation
Yesterday, I posted the a demonstration on how to make a Step Chart in Excel.
You can check out that post here:
How-to Easily Create a...
Create a Excel Gantt Chart to Display a Music Festival Band Schedule
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...
Stop Excel Overlapping Columns on Second Axis for 3 Series
We have learned how to Stop Excel Overlapping Columns in a few posts on the site. A reader had a follow-up question that I...
How-to Find and Replace a Hard Return in an Excel Spreadsheet
In a previous post, I showed you how to add a hard return within an Excel worksheet cell. You can check out that post...
Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second...
A fan of the blog asked a question about this post:
Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...
