Quantcast
How-to Add Resource Names to Excel Gantt Chart Tasks

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 an Excel Chart Series

How-to Select Data Series in an Excel Chart when they are Un-selectable?

6
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...
Network Data Usage Excel Chart

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

16
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...
Excel Overlapping Columns on Second Axis for 3 Series

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

28
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

26
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

2
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

26
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel.  The person...
Line Feed in Excel Cell

Excel Line Break/Hard Return within a Cell

4
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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link