How-to Make an Excel PickList Chart for Multi Years by Month

6
Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month. You can read more about the original...

Friday Challenge – Analyzing Attendance Records with Six Sigma Charts

2
The following is a guest post from Pete on his answer to the most recent Friday Challenge. Pete applied his knowledge of Six Sigma to...

How-to Show Gaps in a Line Chart When Using the Excel NA() Function

3
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart.  In essence, he wanted to...

How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard

4
Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...

USA Today Charts Part 2 – Excel Area Chart with Line and Area Highlights

0
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...

How-to Add a Line to an Excel Chart Data Table and Not to the...

8
Many people making Excel charts love to add a Chart Data Table to their graph.  However, the Excel Data Tables are not very flexible...

How-to Connect Gaps in a Line Chart in Excel

5
When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete.  For instance, you may...

How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart

6
Sales executives are always pushing their sales teams.  They typically do this by setting sales quota’s for their salespeople.  Quotas are thresholds or minimum...

How-to Create an Excel Combined Chart for Tiger Woods Earning and Money Rank

0
Check out this Excel Combined Chart on how much money has Tiger Woods made over his career and also how did he rank in...

3 Ways to Create Vertical Lines in an Excel Line Chart

31
Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish.  We...
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