How-to Add Resource Names to Excel Gantt Chart Tasks
How-to Add Resource Names to Excel Gantt Chart Tasks
I recently received a request from a fan that asked how he could add resource names...
How-to Select Data Series in an Excel Chart when they are Un-selectable?
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...
How-to Visualize 17000 Data Points of Upload and Download Times
In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage.
With so many data points, it...
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...
Stop Excel Overlapping Columns on Second Axis for 3 Series
We have learned how to Stop Excel Overlapping Columns in a few posts on the site. A reader had a follow-up question that I...
How-to Copy Charts and Change References to New Worksheet
Have you ever made a great chart for your Excel Dashboard and you wanted to reuse it for another set of data? Perhaps you...
How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component
Time for some beer and Excel. Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...
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...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
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...