Friday Challenge Answers – Cumulative Events Over Time
In our recent Friday Challenge,
Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time
where a user wanted the following:
Creating a graph of...
Create Dynamic Excel Chart Conditional Labels and Callouts
Chart Conditional Labels and Callouts
Learn how to make the simple and easy these Excel Chart Label Callouts:
In my most recent article, I described how...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart
Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...
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...
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...
Friday Challenge Answer – Create a Percentage (%) and Value Label within 100% Stacked...
Last week I posted a Friday Excel Challenge!. Fun times. How did you do? Spoiler alert, if you don’t know how to create this...
How-to Make a Horizontal Tornado Chart Comparison
Recently in an Excel Forum, a user was asked to create a chart that compared 4 companies by month in a Column Chart.
HOWEVER, there...
Excel Goal Chart Filling a Bottle of Soda
In a previous post, and one of my favorites, I showed you a unique company goal chart using a beer mug instead of a...
How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs
I didn't receive any sample formulas from Friday's post that included a Friday Challenge, so maybe I stumped everyone when asking you to create...