How-to Copy a Chart and Change the Data Series Range References
Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...
How-to Convert an Existing Excel Data Set to a Pivot Table Format
In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...
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...
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...
How-to Make an Excel Project Status Spectrum Chart
Here is the long awaited demonstration of a recent Friday Challenge.
The challenge was to recreate a Project Management Status Chart that I saw on...
Create Dynamic Excel Chart Conditional Labels and Callouts
Chart Conditional Labels and Callouts
Learn how to make the simple and easy these Excel Chart Label Callouts:
In my most recent article, I described how...
Excel Fun Day – Something Fun and Useful That You May Not Know About
Hi All,
Peter reminded me of a really cool option that you have in Excel.
You may have never known about it. But it is fun...
Friday Challenge – Find Unique Values from CSV List
Welcome back to another Friday Challenge at Excel Dashboard Templates!
Today's challenge is pretty straight forward and can be done manually (although it will take...
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...
How-to Make a BETTER Excel Sales Pipeline or Sales Funnel Chart
Learn how to make an accurate sales pipeline in Excel. In previous posts, I have showed you how to make a sales funnel chart...