How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)
Sum Excel Worksheets Technique
Why haven't I known about this simple Excel technique before now?
Maybe you were aware how you can easily Sum Excel Worksheets...
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...
Excel Stacked Area Time Chart – Friday Challenge Answer
In our recent Friday Challenge, a user asked this:
"This is a scatter with smooth line and markers graph. What I would like to have...
How-to Add a Rupee Symbol or a Music Note or a Chess Piece to...
A reader, Matt, after reading this post:
How-to Format Chart Axis for Thousands or Millions
And had the following question:
“How do you use this formula without...
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...
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 Create an Excel Step Chart Formula Using the Small Function
In our last Friday Challenge, we were investigating Step Charts. In case you missed it, you can check it out and download the sample...
Pipeline Challenge Matching Stacked Bar Chart Colors to Products without VBA
In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products. You can check out...
How-to AverageIf Excluding Zeros and Blanks for Non-Contiguous Ranges in Excel
In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude...
Friday Challenge – My Answer – Chart This Data in Excel
Challenge – Chart This Data in Excel - My Answer
A few Fridays ago, I posted this challenge:
Link here: friday-challenge-chart-this-data-in-excel
Where I asked you to send...
