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

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

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

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

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

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

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

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

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

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

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