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 a BETTER Excel Sales Pipeline or Sales Funnel Chart
Learn how to make an accurate sales pipeline in Excel. In previous posts, I have showed you how to make a sales funnel chart...
Add % Difference Data Labels to Excel Horizontal Tornado Chart
Okay, the client is always requesting changes. How do you deal with these? I suggest increasing the contracted hours. In this case, I decided...
How-to Concatenate Excel Column or Row Data Using Google Docs
Yesterday I demonstrated how to find and replace a hard return in an Excel spreadsheet. I presented the last topic before this one so...
How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart
Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...
Friday Challenge – Data Transformation Solution
In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data...
How-to Add Multiple Charts to an Excel Chart Sheet
In past versions of Excel, the default was that your new chart was put into a chart sheet.
You can learn more about chart sheets...
Case Study: Executive Dashboard Chart Creation – Follow-up
The Problem
In a recent post:
“Case Study: Executive Dashboard Chart Creation” (https://www.exceldashboardtemplates.com/?p=1612)
I presented some basic data that you may have in your company that you...
How-to Select Data Series in an Excel Chart when they are Un-selectable?
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse. ...
How-to Make an Excel Clustered Stacked Column Chart with Different Colors by Stack
In a popular post, I showed you how to easily create a Clustered Stacked Column chart in Excel using Multi-Level Category Axis options.
Here is...
