How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps
Project Managers and Executives love Gantt Charts. They also love Microsoft Excel, Charts and Graphs. So it is a natural to consider how you...
How-to Close the Gaps Between Chart Series in an Excel Stacked Clustered Column Chart
Many users like to create a chart that Excel doesn’t have as a chart type. It is a combination of a clustered column and...
How-to Make a Cool Looking 3-D Sales Funnel or 3D Sales Pipeline Chart in...
Some times these types of charts are called funnel charts or some times they are called pipeline charts. Regardless of what you call them,...
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...
How-to Add Resource Names to Excel Gantt Chart Tasks
How-to Add Resource Names to Excel Gantt Chart Tasks
I recently received a request from a fan that asked how he could add resource names...
How-to Create a Time Data Series Step Chart in Excel
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...
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...
What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV...
Recently during a Project that was using Salesforce.com,
I created a custom report and then exported the results to Excel. This report looked and...
How-to Easily Create a Stacked Clustered Column Chart in Excel
Create a Stacked Clustered Column Chart in Excel
There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
Friday Challenge – Part 2 Removing Gaps from a Clustered Column Chart
Okay Excel Fans, in a previous challenge, we had a problem that we solved for a specific data set. We wanted to remove white...
