Analyzing Attendance Records with Charts and Trend Line with Sparklines
A big shout out to Don who sent in this solution to last week’s Friday Challenge: Analyzing Attendance Records with Charts and Trend Line. ...
Friday Challenge: What is your answer vs. Excel?
There is a Facebook post going around and I thought it would be a fun Friday Challenge edition.
What is your answer to this this...
Data Transformation – Excel Array Solution
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages. Well although...
How to easily change chart element selections in Excel 2016 2019 and Office 365
Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip.
The...
Presenting Metrics Data – How would you create a chart for this data?
In my last post I asked how you would create a chart for this request:
Presenting Metrics Data
Trying to find the best way to...
How-to Create a Stacked Clustered Column Chart with 2 Axes
In response to another post of mine, EC wrote:
“My issue: This site has been really helpful so far! I have a follow up question....
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 – Chart This Data in Excel
Chart This Data in Excel
Today's challenge is a simple one but has many answers. You will be presented with a small set of data and I...
IMDB Top 250 Movies of All Time – Excel Dashboard Tutorial
In our last Friday Challenge, we presented a data set of the Top 250 Movies from IMDB and asked you to create a dashboard...
Terrible Chart Tuesday – Excel 3-D Clustered Column Chart
Welcome to another edition to Terrible Chart Tuesday. Here we see an example of what I think is a Terrible Chart that was create...
