
Friday Challenge – Step Chart for an Excel Time Series
I was recently asked for assistance with this request: Hi Steve, I am trying to make a hypnogram with data that we collected over the course of a day. I want the y-axis to denote wake (W), o

I was recently asked for assistance with this request: Hi Steve, I am trying to make a hypnogram with data that we collected over the course of a day. I want the y-axis to denote wake (W), o

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 cumulative events over time I

Create a chart that can indicate at what time a value increased in a certain column of data.

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.

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

You might be asking yourself, “What is a Step Chart?” You have probably seen one, but didn’t know that it is called a step chart. Here is what one looks like: Why use a step chart? Step char