How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
Friday Challenge – Mimic Newspaper Chart Line Style in Excel
Hi All,
Here is a fun challenge that I thought you might like. I saw this chart in the Denver Post and I wondered how...
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...
Free Dashboard Template Download – BMI Weight Tracker
In this ever expanding universe, so is my belt. I need to drop more than a few pounds.
Now I can use an Excel Dashboard...
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...
Create a Vertical Line Between Columns in Excel Using Error Bars
Create a Vertical Line Between Columns in Excel Using Error Bars
Thanks to Leonid (a super fan) for advising me on another and possibly better...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
Friday Challenge – The Boss Says “Can you create some graphs?”
Here is the scenario that thrills Excel data analysts and sends chills down most employee’s spines:
Thursday afternoon: Your department sent out an Excel spreadsheet...
Friday Challenge On Thursday – Only Show Selected Data Points in an Excel Chart
Hi Excel Fans,
Today I am posting the Friday Challenge a day early to give you time to try it out.
Here the user story on...
Class Exam Grade Excel Chart Using Slicers and a Pivot Table
Here is Don’s amazing reply to the recent Friday challenge.In this example, Don has elevated his Excel Slicer Pivot Charting to a whole new...











