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 Make an Excel Chart with 3 Different Column Widths (Bullet Chart Option 2)

In are recent post, I showed you how to create a Bullet Chart in Excel.  Pete, then sent me another way to create a...

How-to Show Decades and Highlight a Year in the Horizontal Axis

4
Recently in an Excel Forum, a user had data similar to this format: Here is what he wanted to do:   How do I set the Horizontal...
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...

Add Multiple Percentages Above Column Chart or Stacked Column Chart

0
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart.  You can see the...

Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second...

A fan of the blog asked a question about this post: Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...

A Taxing Situation…

0
In order to prevent vehicle population from growing too fast and also to ease traffic, Shanghai China has begun to auction off license plates. ...
Better Format for Excel Chart Secondary Axis Columns Overlap with 3 Series

A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series

Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series. The Problem I didn’t love the last chart we...

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

Leonid’s Friday Challenge Answer – Pipeline Usage Stacked Bar Chart

Here is a late entry :) Thanks Leonid.  This is an Awesome response! Leonid was responding to this recent challenge:  Friday Challenge – Pipeline Usage...