How-to Mimic a Newspaper Chart Line Style in Excel
In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart...
Friday Challenge – Find Unique Class List in Excel ANSWER
On Friday, I posted this challenge:
https://www.exceldashboardtemplates.com/friday-challenge-find-unique-list-in-excel/
You can download the sample data set here: Challenge Sample Data
Check out the post and download / try it yourself before you...
How-to Make a Dynamic Hotel Ballroom Occupancy Chart
In a previous Friday’s challenge, I presented the following user request.
Here was the question again and what you would have seen in the download...
3 Ways to Create Vertical Lines in an Excel Line Chart
Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish. We...
Data Transformation – Excel Array Solution
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages. Well although...
Quickest Way to Select and Align Charts for an Excel Dashboard
Select and Align Charts for an Excel Dashboard
Creating dashboards can take a lot of time. With this simple technique that I just learned, you...
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...
How-To Create an Excel Step Chart Formula Using the Small Function
In our last Friday Challenge, we were investigating Step Charts. In case you missed it, you can check it out and download the sample...
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that...
USA Today Charts Part 2 – Excel Area Chart with Line and Area Highlights
Well, I have been working hard on my project and it has successfully launched. But that took time away from my other passion, EXCEL!!!
So...