Grab the file I used in the video from here 👉 pages.xelplus.com/step-chart-file

Thanks for the Step-rific chart and formulas!!

@LeilaGharani

6 жыл бұрын

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!

@LeilaGharani

6 жыл бұрын

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 :)

Super cool, thanks

Amazing!!!!

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!!

@LeilaGharani

6 жыл бұрын

Sure. Thank you for the content and the template :)

Your Creativity Level is Remarkably best☺

Amazing, interesting and helpful, as always. Thank you, Leila.

@LeilaGharani

6 жыл бұрын

You're very welcome Celia.

Excellent, thanks a lot.

That was really great, so many useful tips there, the odd rows, using names in chart ranges and so on. Thanks!

@LeilaGharani

6 жыл бұрын

You're welcome Terry. I like the Odd rows idea from Bart as well.

Very thanks Leila, very appreciate for your contribution

@LeilaGharani

6 жыл бұрын

You're welcome Fares.

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.

@LeilaGharani

6 жыл бұрын

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 :)

Awesome... Like the chart

Hi Leila, Once again you provided a great tutorial, Thank you!

@LeilaGharani

6 жыл бұрын

You're welcome Chaminda.

Thank you Leila, you have beautifully explained and it is very helpful.

@LeilaGharani

6 жыл бұрын

Happy to hear that Fareed.

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.

@LeilaGharani

6 жыл бұрын

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 KZread as well :)

@1gopalakrishnarao

6 жыл бұрын

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.

Wonderful LG as always!

@LeilaGharani

6 жыл бұрын

Glad you like it TZ :)

a fascinating gem again! thank you! :)

@LeilaGharani

6 жыл бұрын

You're very welcome Gabor.

Leila thank you for your tips.

@LeilaGharani

6 жыл бұрын

You're very welcome Cherrell. Thank you for your support.

Very nice! Thank you.

@LeilaGharani

6 жыл бұрын

You're welcome Nishant.

you are just perfect thank you Ms. Leila

@LeilaGharani

6 жыл бұрын

Thank you Ismail for your support & very kind comment.

Actually it was so interesting...I like a lot the way you explain things. Really Professional.

Wow super cool trick

Excel MVP!

This was just amazing

@LeilaGharani

6 жыл бұрын

Glad you like it Alex :)

yeah, great, mind blowing and useful

@LeilaGharani

6 жыл бұрын

Very happy to hear that :)

great leila really really helpful

@LeilaGharani

6 жыл бұрын

You're welcome & thanks to Bart for providing the template.

Very useful techniques :)

@LeilaGharani

6 жыл бұрын

Yes - Thanks to Bart for the great input.

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

@LeilaGharani

3 жыл бұрын

That's great, Thomas! Glad the video was helpful.

Mind blowing LG .. 😱

@LeilaGharani

6 жыл бұрын

Thanks Dev. It's Bart's idea so the credit goes to him :)

You always have a brilliant demonstration. How would you do the same when dealing with Pivot Tables? Thank you

you are a best teacher of MS excel. thanks

@LeilaGharani

6 жыл бұрын

Ohh thank you very Seion. Thanks for the support.

@davidhansen527

5 жыл бұрын

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.

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.

EXCELlent! :)

@LeilaGharani

6 жыл бұрын

Thanks Malina for dropping by :)

@MalinaC

6 жыл бұрын

:)

Watched the video again. Was wondering if you can do the conditional formatting with older versions of Excel (e.g. 2010). Thanks

Awesome video. 30 minutes flew past!

@LeilaGharani

4 жыл бұрын

I forgot I made such long videos. Glad you managed to stick around until the end :)

thanks thanks thanks

Hi leila i like to see how you explained in your video.

Great video - could it be updated using xlookup and the other functions available from Office 365? -Thanks!!

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;...)

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?!

@LeilaGharani

6 жыл бұрын

You're welcome Abdelrahman. Bart answered your question in the comments above....

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!

Is there any way to use this water flow chart with pivot tabkes

Beauuutyyy

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 😁😁😁

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

@LeilaGharani

6 жыл бұрын

Thank you for watching. Glad you like it...even though it's lengthy :)

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

@LeilaGharani

6 жыл бұрын

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 :)

@TAMANNASHAMIMA

7 ай бұрын

Hello

@TAMANNASHAMIMA

7 ай бұрын

Mam you russian

nice for knowledge but your are very smart mam

@LeilaGharani

6 жыл бұрын

no not smart - just enjoy working with Excel :) Thank you for your comment and support.

Hello, Its a great step by step chart. Is it possible to use week number or month name instead of date values?

@LeilaGharani

6 жыл бұрын

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".

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?

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.

@LeilaGharani

4 жыл бұрын

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.

@TheJoeman187

4 жыл бұрын

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?

@TheJoeman187

4 жыл бұрын

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.

but your knowlege is very good

@LeilaGharani

6 жыл бұрын

Thank you :) Appreciate your support.

Half an hour for chart tutorial, Microsoft is blamed here !!