Awesome dynamic step chart. I decided to test a few things and learned some interesting staff. For labels formulas you do not have to check if they are odd because if they are bigger or smaller, they are odd, because the value of the price is repeated. For charts, you only need a dynamic range for the series other ranges can be left to the maximum, and the whole chart is still dynamic. Thanks again for the movie!
That's great!!!! Thanks for the testing and the feedback. Agree about the extra named ranges. We're always starting from the beginning of the data prep. so they aren't necessary for the other chart elements. You're right about the odd part of the data labels. The check for the change is enough. Perfect! It's even more optimized now. I'll update the template tomorrow. Thanks for the comment :)
So many useful things in one place. It's just amazing. Just looked at the video length - 30 min. Couldn't believed. It was so interesting that time passed so quickly.
Hello Leila, thank you for making this video. Very interesting and fun to see that you explain the things almost exactly as I thought it should be. Well done, patiently and with lots of intermediate steps. As for the comment of Abdelraham, that is correct. In a real model you can always add check IF the first entry is on an even or an odd line. If not: remove or add a row!!
Yes Once again, your intelligence/innovative idea has been displayed. Hats Off!!!!!!!!!!!! to my beautiful and brilliant teacher. I hope and trust that God is only giving you the strength, intelligence and everything to help the Excel lovers/addicts/learners. No words to express my gratitude in guiding the Excel topics/tricks/charts. Waiting eagerly for your VBA videos. A big SALUTE.
Thank you very much Gopala as always for your very kind comments and support. Yes, I am currently recording the VBA material for the course and will put some up on TH-cam as well :)
Thank you very much Madam, I appreciate and respect your zeal, enthusiasm, vigour, grit, dexterity and tenacity in doing this videos. Great indeed. Respectful Salute.
Thanks Leila for your valuable video. Kindly provide VBA related Video also. Last year you had promised that you will provide VBA Video. Because your way of teaching and presentation is marvelous.
I like the way Leila breaks down all the steps and also the overall goals of the steps. For example, using a formula in name manger so you can use a formula in chart data. Plus the goals of the steps telling us the goals of the next steps, for example telling us the next steps are to improve the readability of the chart. along with why it impoves the readablity.
Dear Leila, late response, but you have made my day today (as always)! My new graphs are looking amazing!! Thanks a lot for this great video!! Best regards Thomas
Thanks for explaining clearly how to build an step chart in excel. I am trying to build a step chart using a text (station names) in replacement of dates explained. But when i convert all the dates in to text (say A, B, C,D….. so on), the excel chart is converting to normal chart with inclined lines. Can you help me out in building an step chart using texts. Thank You!
Thanks for sharing such a wonderful video. Just I have a thought if a add a row in the above of the data is it will change the step chart? Because of the isodd formula?!
Gd evening madam A bit leanthy process but very very intersting and impressive to explain the whole process I am fan of urs way of Explaing the problems Thanks very much for all these videos
Hi Leila, Great video as always. Trying to find another approach with familiar formulas (though I don't use IsODD or IsEven very much). I wonder if you could substitute the Isodd function with IsEven or the Mod function? . Also, could you substitute a dynamic range formula using index and counta instead of using Offset (to avoid using volatile functions)? I always cringe when I have to use Offset because I tend to this function in larger spreadsheets (and you know how too many formulas slow down calculation time). This video reminds me of doing a cross word puzzle with Sherlock Holmes: sniffing around to find solutions to one answer which then leads to another question with a huge magnifying glass. I've been thinking about this for awhile but I haven't tested or tried this technique out yet. Instead of putting formulas in the cells directly would it be more efficient to put them in the name manager. This way, someone couldn't come along and break the formula by modifying the formula arguments. I think also if you made a change to the formula in the name manager you wouldn't have to copy down the changes to the other cells providing it isn't in a table. Michael
Thanks Michael - Yes Index could replace offset here too. I find offset easier to write for this type of range referencing. Since it's just one drop-down it will probably not impact performance. But if there were more, I agree - it would be better to use Index instead. You're right - it's like a cross word puzzle that's fun to solve :)
Hi Leila, If you get this, I just wanted to let you know you have really helped me understand Excel. I like your videos and so glad that you provide the workbooks that helps a lot. I like to make my own and follow along to your videos. On this one I think I followed your instructions but my step line is all screwed up. It's updating and the labels are correct. Not sure why the line isn't like yours. When I did the offset formula I got a different number than you did. But I checked and rechecked and not sure how. I got 43842 instead of 42747. I almost got it and i'm sure that's the reason. Can you help me fix it? Thanks, Joe, from Michigan.
Thanks for replying so quickly Leila. This is the only thing that I can come up with when comparing your chart to mine: {43842;43862;43862;43881;43881;43905;43905;43931;43931;43956;43956;43988;43988;44019;44019;44051;44051} My total is 43842 compared to yours 42747. And the rest of them are different. Any ideas?
Hi Leila, I did find out what happened. Now it's working perfect. Fun chart to make. Is there a way where I can put a comment next to the labels to indicate a reason why it fluctuates up or down? Just wondering...Thanks again for your help. Hope you are safe and healthy.
How can I do it when my x-axis is text? I havde followed your steps using my own data, but my x-axis has double lables on the axis. I am using company names on x-axis How can fix this?
Grab the file I used in the video from here 👉 pages.xelplus.com/step-chart-file
Thanks for the Step-rific chart and formulas!!
You're very welcome Mike.
Epic video, not only for the step chart per-se, but how you unlocked the secret world - at least for me - of handling chart labels. Epic video
Gosh, this is absolutely brilliant. Thanks Laila.
Awesome dynamic step chart.
I decided to test a few things and learned some interesting staff.
For labels formulas you do not have to check if they are odd because if they are bigger or smaller, they are odd, because the value of the price is repeated.
For charts, you only need a dynamic range for the series other ranges can be left to the maximum, and the whole chart is still dynamic.
Thanks again for the movie!
That's great!!!! Thanks for the testing and the feedback. Agree about the extra named ranges. We're always starting from the beginning of the data prep. so they aren't necessary for the other chart elements.
You're right about the odd part of the data labels. The check for the change is enough. Perfect! It's even more optimized now. I'll update the template tomorrow. Thanks for the comment :)
Thank you Leila, you have beautifully explained and it is very helpful.
Happy to hear that Fareed.
That was really great, so many useful tips there, the odd rows, using names in chart ranges and so on. Thanks!
You're welcome Terry. I like the Odd rows idea from Bart as well.
Amazing, interesting and helpful, as always. Thank you, Leila.
You're very welcome Celia.
So many useful things in one place. It's just amazing. Just looked at the video length - 30 min. Couldn't believed. It was so interesting that time passed so quickly.
I was also surprised to see the time after I stopped recording. This is the longest video to date. Glad to hear the time went by fast :)
Hello Leila, thank you for making this video. Very interesting and fun to see that you explain the things almost exactly as I thought it should be. Well done, patiently and with lots of intermediate steps. As for the comment of Abdelraham, that is correct. In a real model you can always add check IF the first entry is on an even or an odd line. If not: remove or add a row!!
Sure. Thank you for the content and the template :)
Very thanks Leila, very appreciate for your contribution
You're welcome Fares.
Super cool, thanks
Hi Leila,
Once again you provided a great tutorial,
Thank you!
You're welcome Chaminda.
Your Creativity Level is Remarkably best☺
you are just perfect thank you Ms. Leila
Thank you Ismail for your support & very kind comment.
Amazing!!!!
Excellent, thanks a lot.
Actually it was so interesting...I like a lot the way you explain things. Really Professional.
Wonderful LG as always!
Glad you like it TZ :)
a fascinating gem again! thank you! :)
You're very welcome Gabor.
Awesome... Like the chart
Leila thank you for your tips.
You're very welcome Cherrell. Thank you for your support.
Very nice! Thank you.
You're welcome Nishant.
Yes Once again, your intelligence/innovative idea has been displayed. Hats Off!!!!!!!!!!!! to my beautiful and brilliant teacher. I hope and trust that God is only giving you the strength, intelligence and everything to help the Excel lovers/addicts/learners. No words to express my gratitude in guiding the Excel topics/tricks/charts. Waiting eagerly for your VBA videos. A big SALUTE.
Thank you very much Gopala as always for your very kind comments and support. Yes, I am currently recording the VBA material for the course and will put some up on TH-cam as well :)
Thank you very much Madam, I appreciate and respect your zeal, enthusiasm, vigour, grit, dexterity and tenacity in doing this videos. Great indeed. Respectful Salute.
Excel MVP!
Watched the video again. Was wondering if you can do the conditional formatting with older versions of Excel (e.g. 2010). Thanks
This was just amazing
Glad you like it Alex :)
You always have a brilliant demonstration.
How would you do the same when dealing with Pivot Tables?
Thank you
Wow super cool trick
yeah, great, mind blowing and useful
Very happy to hear that :)
great leila really really helpful
You're welcome & thanks to Bart for providing the template.
Very useful techniques :)
Yes - Thanks to Bart for the great input.
Thanks Leila for your valuable video. Kindly provide VBA related Video also. Last year you had promised that you will provide VBA Video. Because your way of teaching and presentation is marvelous.
you are a best teacher of MS excel. thanks
Ohh thank you very Seion. Thanks for the support.
I like the way Leila breaks down all the steps and also the overall goals of the steps.
For example, using a formula in name manger so you can use a formula in chart data. Plus the goals of the steps telling us the goals of the next steps, for example telling us the next steps are to improve the readability of the chart. along with why it impoves the readablity.
Dear Leila,
late response, but you have made my day today (as always)! My new graphs are looking amazing!!
Thanks a lot for this great video!!
Best regards
Thomas
That's great, Thomas! Glad the video was helpful.
Hi leila i like to see how you explained in your video.
Awesome video. 30 minutes flew past!
I forgot I made such long videos. Glad you managed to stick around until the end :)
Mind blowing LG .. 😱
Thanks Dev. It's Bart's idea so the credit goes to him :)
thanks thanks thanks
EXCELlent! :)
Thanks Malina for dropping by :)
:)
Thanks for explaining clearly how to build an step chart in excel.
I am trying to build a step chart using a text (station names) in replacement of dates explained. But when i convert all the dates in to text (say A, B, C,D….. so on), the excel chart is converting to normal chart with inclined lines.
Can you help me out in building an step chart using texts.
Thank You!
Great video - could it be updated using xlookup and the other functions available from Office 365? -Thanks!!
Thanks for sharing such a wonderful video.
Just I have a thought if a add a row in the above of the data is it will change the step chart? Because of the isodd formula?!
You're welcome Abdelrahman. Bart answered your question in the comments above....
Thanks Leila. could i create a step chart if axis is not a date, example axis is a interval time ( 09:00-09:30;09:30-10:00;...)
Beauuutyyy
Is there any way to use this water flow chart with pivot tabkes
Gd evening madam
A bit leanthy process but very very intersting and impressive to explain the whole process
I am fan of urs way of Explaing the problems
Thanks very much for all these videos
Thank you for watching. Glad you like it...even though it's lengthy :)
I need some videos about animated chart using mouse over event procedure.
Gd mng madam
Thanks for ur reply
I think u like to solve difficult problems 😁😁😁
Hi Leila,
Great video as always.
Trying to find another approach with familiar formulas (though I don't use IsODD or IsEven very much).
I wonder if you could substitute the Isodd function with IsEven or the Mod function? .
Also, could you substitute a dynamic range formula using index and counta instead of using Offset (to avoid using volatile functions)? I always cringe when I have to use Offset because I tend to this function in larger spreadsheets (and you know how too many formulas slow down calculation time).
This video reminds me of doing a cross word puzzle with Sherlock Holmes: sniffing around to find solutions to one answer which then leads to another question with a huge magnifying glass.
I've been thinking about this for awhile but I haven't tested or tried this technique out yet.
Instead of putting formulas in the cells directly would it be more efficient to put them in the name manager. This way, someone couldn't come along and break the formula by modifying the formula arguments. I think also if you made a change to the formula in the name manager you wouldn't have to copy down the changes to the other cells providing it isn't in a table.
Michael
Thanks Michael - Yes Index could replace offset here too. I find offset easier to write for this type of range referencing. Since it's just one drop-down it will probably not impact performance. But if there were more, I agree - it would be better to use Index instead.
You're right - it's like a cross word puzzle that's fun to solve :)
Hello
Mam you russian
Hello, Its a great step by step chart.
Is it possible to use week number or month name instead of date values?
Yes - you could put in a date, but show the label as month name by adjusting the formatting for date to for example "mm" or "mmm".
nice for knowledge but your are very smart mam
no not smart - just enjoy working with Excel :) Thank you for your comment and support.
Hi Leila, If you get this, I just wanted to let you know you have really helped me understand Excel. I like your videos and so glad that you provide the workbooks that helps a lot. I like to make my own and follow along to your videos. On this one I think I followed your instructions but my step line is all screwed up. It's updating and the labels are correct. Not sure why the line isn't like yours. When I did the offset formula I got a different number than you did. But I checked and rechecked and not sure how. I got 43842 instead of 42747. I almost got it and i'm sure that's the reason. Can you help me fix it? Thanks, Joe, from Michigan.
Please download my workbook (link is in the description of the video) and compare it with my solution. Hope it'll help to find the issue.
Thanks for replying so quickly Leila. This is the only thing that I can come up with when comparing your chart to mine: {43842;43862;43862;43881;43881;43905;43905;43931;43931;43956;43956;43988;43988;44019;44019;44051;44051} My total is 43842 compared to yours 42747. And the rest of them are different. Any ideas?
Hi Leila, I did find out what happened. Now it's working perfect. Fun chart to make. Is there a way where I can put a comment next to the labels to indicate a reason why it fluctuates up or down? Just wondering...Thanks again for your help. Hope you are safe and healthy.
How can I do it when my x-axis is text?
I havde followed your steps using my own data, but my x-axis has double lables on the axis. I am using company names on x-axis
How can fix this?
but your knowlege is very good
Thank you :) Appreciate your support.
Half an hour for chart tutorial, Microsoft is blamed here !!