Create a step chart in Excel | Excel Off The Grid | The fastest way
★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Download the example file★
exceloffthegrid.com/how-to-cr...
★ About this video ★
In this video, we look at how to create a step chart in Excel
- Option 1: The most common method
- Option 2a: The fastest method
- Option 2b: Using Excel Tables
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel #StepChart #DataViz
Пікірлер: 34
The Union Operator method is the best I have seen so far to create a step chart quickly!
This is so secret feature. I haven't ever seen like this method. It is so interesting and I will try it. Thank you so much for sharing this tip
@ExcelOffTheGrid
2 жыл бұрын
Thanks Emre - there are lots of interesting techniques in there 👍
ABSOLUTELY INCREDIBLE ! You are a genius ! Thanks for making such beautiful free videos. God Bless !
@ExcelOffTheGrid
Жыл бұрын
Thanks. I’ve not seen anybody else use this method using a range union. So, I’m glad you like it.
Thanks a lot... out of the box all the time.. Please keep creating more videos about excel charts Couldn't describe more how much its useful
Nice step chart examples! Thanks for demonstrating. Thumbs up!!
@ExcelOffTheGrid
2 жыл бұрын
Thanks Wayne. As always, I appreciate your feedback & comments.
Always excellent tutorial from Mark!👍👍
@ExcelOffTheGrid
Жыл бұрын
Thanks Kebin - Glad you enjoyed it
Thank you
simply brilliant, thanks for sharing! 👍
@ExcelOffTheGrid
10 ай бұрын
My pleasure! 😁
Fantastic, fantastic Mark! amazing approach, mind-blown about the possibilities on Option 2. Still processing it...
@spilledgraphics
11 ай бұрын
I would add an third option with VSTACK: array for dates: = VSTACK( INDEX( Data[Date], 2 ) : INDEX( Data[Date], ROWS( Data[Date] ) ), Data[Date] ) array for values: = VSTACK( INDEX( Data[Rate], 1 ) : INDEX( Data[Rate], ROWS( Data[Rate] ) - 1 ), Data[Rate] ) Then you defined names this spilled ranges. Again, amazing Mark!
@ExcelOffTheGrid
11 ай бұрын
I know right!!! Unfortunately the blog post doesn’t rank high enough so nobody knows about it 🤷♂️ 😂 3rd option… NICE!!! 🍬 I probably need to update for the new dynamic arrays.
thank you. Every tutorial was using duplicated data which is fine for small amounts of data but not 1m points plus
@ExcelOffTheGrid
10 ай бұрын
Exactly, the duplicates data doesn’t seem like a good option to me. 👍
Thanks and Question about Text or Values instead of Dates: Thank you for this walkthrough, it's a great solution that addresses the most commonly imaginable circumstances. Step charts in general appear to be conditional upon values being associated with recognized dates ("01/01/2012", "04/08/2016", "02/11/2017", etc) but I've come across a need where generic names are desired (such as "FY24 Q1", "FY24 Q2", "FY24 Q3", etc). However, whenever I do this, Excel, Power point, etc appear to loose the step chart function. Have you found a way to generate a step chart with generic text or values instead of dates?
Very nice trick (if you can call it that!). Thanks for sharing. And, nicely done video.
@ExcelOffTheGrid
2 жыл бұрын
Thanks 😀 I think the first method is a trick, I think the others are application of know techniques.
@bbotzong
2 жыл бұрын
@@ExcelOffTheGrid sorry, trick was not the right word. What you showed was very clever. Thanks!
Can we make dinamic step chart from pivot table data?
I like the second option. Will this work with x-axis not being a date but with time (sec)? Somehow the second option is repeating data on x-axis and plotting repeated data instead of step plot.
@nithinteja8730
7 ай бұрын
I see that this option only works when you convert your x-axis data to Date type if it is different it will created regular line plot
Can we create step chart with numbers instead of dates please? It's always considering the numbers as text and repeating the value twice on the chart.
@ExcelOffTheGrid
5 ай бұрын
Just set jt as a date axis and it will work the same.
this is great. But I tried to use this in a combo chart. but it does not work. what can be the reason?
@ExcelOffTheGrid
Жыл бұрын
It duplicates the data points along a date axis, so your chart data likely has incompatible number of data points.
Hi, i am trying to this for time based data, but this is not helping me to form a step chart. Can you tell me why this wont work for time on x axis and anyway out of this?
@ExcelOffTheGrid
2 жыл бұрын
Maybe: Is your axis formatted as a date axis? Is the data text that looks like a date?
when im creating the chart it dont put walues to x it makes 2 lines
Very useful content, thanks a lot! It's just a static version w/o header from Mark's Option1, but it works with ranges, structured references and defined names as well. So only for lazy excel users 🤣🤣🤣 -------------------------------------------------------------------------------------------------------------------------- The function, based on the specified dates and values, prepares the source data for the X and Y axes of a Step Chart. Criteria: COUNTA(dates)=COUNTA(values) ARGS: (dates), (values) -------------------------------------------------------------------------------------------------------------------------- StepChartStaging=LAMBDA(dates, values, LET( criteria, COUNTA(dates) = COUNTA(values), dateoffset, DROP(dates, 1), valueoffset, DROP(values, -1), datecolumn, VSTACK(dateoffset, dates), valuecolumn, VSTACK(valueoffset, values), basetbl, HSTACK(datecolumn, valuecolumn), staging, IF( criteria, basetbl, "The row numbers of the (dates)(values) columns do not match!" ), staging)) --------------------------------------------------------------------------------------------------------------------------
@ExcelOffTheGrid
Ай бұрын
I really need to update this video for dynamic arrays. Thanks for the reminder.