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...
Case Study: Executive Dashboard Chart Creation – Follow-up
The Problem
In a recent post:
“Case Study: Executive Dashboard Chart Creation” (https://www.exceldashboardtemplates.com/?p=1612)
I presented some basic data that you may have in your company that you...
How-To Make a Dynamic Excel Scroll Bar Chart Part 2
Wow, it has been over 2 years. I am so sorry if you have been waiting all this time. Probably not, but I will finish...
Step-by-Step Horizontal Bar Chart with Vertical Lines Tutorial
In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...
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...
How-to Add a Line to an Excel Chart Data Table and Not to the...
Many people making Excel charts love to add a Chart Data Table to their graph. However, the Excel Data Tables are not very flexible...
Friday Challenge Answer Part 1: Splitting Up Email Address Text
Hi All,
Here is the easy answer to the Friday Challenge on:
"How-to Split Up Email Address Text for First Middle Last Names"
Please check out the...
This is the Bomb: or How I came to love the Offset function
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...
How-to Create a Scroll Bar in Excel to Make Your Dashboard Dynamic
This is part 1 of creating a dynamic Excel dashboard chart using the scroll bar control.
So in the title I said that we would...
How-to Easily Make a Dynamic PivotTable Pie Chart for the Top X Values
I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5...
