Array
Understanding How-to Make a Step Chart in Excel Using Index and Match Functions
Understanding How-to Make a Step Chart in Excel Using Index and Match Functions in an Array formula.
EXPLORE THE LIBRARY
/category/chart/page/10/
Chart
How-To Create an Excel Step Chart Formula Using the Small Function
How-to create your step chart data with a formula using SMALL and VLOOKUP. Check it out in the Step-by-Step, Video Tutorial and Free Sample File Below.
Challenge
Friday Challenge: Excel Step Chart Automation
Yesterday, I posted the a demonstration on how to make a Step Chart in Excel. You can check out that post here: How-to Easily Create a Step Chart in Excel However, the process of setting up
Challenge
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
Friday Challenge Analyzing Attendance Records with Six Sigma Charts
Basketball
How-to Make a College Basketball Tournament Bracket Chart in Excel
Learn How-to Make a College Basketball Tournament Bracket Chart in Excel.
Challenge
Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data. Read it over, but really, the last line of the request is my favorite “other ways”. This can be with one chart
Chart
How-to Fake an Excel Chart Data Table
In this tutorial, you will see an extended technique on creating a more flexible Excel Chart Data Tables.
Chart
How-to Show Text in an Excel Chart Data Table (Part 1)
Learn 2 Excel Chart techniques on how you can create a more flexible Excel Chart Data Tables. One that shows how you can put in Text in the data table.
Chart
Excel Goal Chart Filling a Bottle of Soda
Learn how to make a company thermometer chart by using soda and a bottle in Excel.
Chart
Friday Challenge – Close the Distance Between a Clustered Stacked column Chart
Friday Challenge - Close the Distance Between a Clustered Stacked column Chart