How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel
Excel is awesome because, even when a certain chart type is not a standard option, there may be...
Copy Paste vs Fill Handle Copy with Tables References in an Excel formula
In this recent post:
Friday Challenge Answers – Cumulative Events Over Time
I created a formula that referenced a table. As I created my video I...
How-to Make a USA Today Pie Chart Graph – Replicating All Charts in USA...
I have been traveling very frequently for business as a Salesforce.com Software Consultant, so I spend a lot of time in hotel’s and airports. ...
How-to Group and Categorize Excel Chart Legend Entries
If you have a chart with Legends, then you should check out this tutorial.
Recently when working on a solution for a fan, I noticed...
Friday Challenge Answer – Find Unique Values from CSV List
Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List
Before we begin, I am going to show...
How-to Concatenate Excel Column or Row Data Using Google Docs
Yesterday I demonstrated how to find and replace a hard return in an Excel spreadsheet. I presented the last topic before this one so...
Excel Line Break/Hard Return within a Cell
Most people don't know that you can put a Hard Return (Line Break) within a cell because when they hit enter Excel takes them to...
How-to Make Excel STOP Selecting Range/Extending Range
While building your Excel Dashboard Templates, have you had the frustrating problem where Excel keeps highlighting a range of cells as you click on...
How-to Format Trend Line Color in Excel Dynamically
Many users use Trend Lines in Excel charts and graphs. They may also be used in Company Dashboards, but to you can make your...
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...
