Tag: Column Chart
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...
How-to Create an Excel Dashboard Column Chart with 2 Axis Groupings
Recently I saw this in the MrExcel Forums. The title “Weird Charts with 3 Axis” intrigued me.
I determined that they were looking to put...
Add Multiple Percentages Above Column Chart or Stacked Column Chart
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart. You can see the...
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 Make Longer Legend Color Bars in an Excel Chart Video Tutorial
Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph. However, this...
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
Grouping Excel Column Charts with a Box
In a previous post, I showed you how to group a column chart with lines:
You can check out the posting here:
Group Column Chart...
Budget Analyst Question: My Answer
Last week I posted this:
Budget Analysts might be asked by their executive team, managers or co-workers.
Question Title: Bar Graph Below the Line
I need a...
How-to Make a Wall Street Journal Horizontal Panel Chart in Excel
In a recent Wall Street Journal article I saw the following chart regarding Dropbox, YouSendIt and Box.com. The graph describes how many people use...
How-to Make Conditional Label Values in an Excel Stacked Column Chart
Recently I was thinking that sometimes when you make a Stacked Column Chart in your Excel Dashboard, you may want to hide some of...
