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

Bravo Medhi and Leila. Beautiful application to errors bars and table (to make the chart dynamic).

Wow ! Just Wow. I had never used Error Bars before this.

I love all your tutorials!!!

@LeilaGharani

Жыл бұрын

🙏Thanks, Stacey!

Excellent one. Thank you

This was brilliant fun to make.

Excellent presentation of this technique And not only that! Leila has masterfully refreshed the technique of creating step chart originating from MVP Tushar Mehta from 20 years ago

Thanks Leila for the chart expertise!

@LeilaGharani

6 жыл бұрын

You're very welcome Kevin.

Really awesome! Thank you to all three of you!

@LeilaGharani

6 жыл бұрын

That's team work! Nothing can beat that :) Great to see you Celia.

@bricc322

6 жыл бұрын

Indeed, Leila! Impossible to beat specially when the team is all 5 - stars! Great to see you too, Leila! In fact I see you every night - I am taking your Dashboards course on Udemy. The VBA one is next in the queue. ;-)

@LeilaGharani

6 жыл бұрын

;-) I hope you're enjoying the dashboard course - hopefully it's not giving you any nightmares ;)

@bricc322

6 жыл бұрын

Leila Gharani HAHAHA! Not at all, Leila. On the contrary: it makes me very happy to learn all that new stuff.

Thanks LG....💞 Awesome and smooth error bar. Thanks to give us this amazing video without any cost. I respect your important time values 💞 Love the way of ur presentation Lots of love🌷🌹🌷🌹

@LeilaGharani

6 жыл бұрын

Thank you Dev! I love creating the videos too and sharing them with others who also enjoy working with Excel. Many thanks for your support.

This is the right time to use error bars, thanks

Pure beauty in action

So many cool useful tricks! Thanks a lot for sharing!

@LeilaGharani

6 жыл бұрын

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

Very nice video. Never worked with error bars. I always thought they were only for shares on the stock market. Good to see how you can modify these error bars.

@LeilaGharani

6 жыл бұрын

Thanks Bart and thank you for the whole step chart idea. Yes - error bars can really come in handy - in this case for cosmetic purposes rather than statistical analysis :)

Leila, discovered your channel very recently, but super impressed. This is awesome!

@LeilaGharani

6 жыл бұрын

Thank you! I'm happy to hear that!

Thanks Leila. That's great, made chart not boring anymore

@LeilaGharani

4 жыл бұрын

You're welcome 😊

Thanks Ms. Leila I really appreciate

@LeilaGharani

6 жыл бұрын

Thank you! Appreciate your support.

Leila, You are simply Awesome....

@LeilaGharani

5 жыл бұрын

Glad you like it Samuel :)

This is WOW 😮

Wow, I love this! This has inspired me to improve the stacked area charts that I'm currently using to show balance changes over time, as steps would be more suitable. I have a dollar value recorded for each date within the given range, so I'm thinking the easiest method would be to use a stacked column chart and change the spacing between each column to 0 so that there is no space between each column. I'm sharing this in case others find it useful, though I'm also interested to know if there are other methods to achieve this!

@LeilaGharani

3 жыл бұрын

Thanks for your tips, Ashlee!

I love error bars :) Thank's for the EXCELlent film, Leila!

@LeilaGharani

6 жыл бұрын

Thank you Malina! Agree - error bars come in really handy. I wonder how many people use them for their actual purpose.....

@MalinaC

6 жыл бұрын

Hehe, yeah, ...not me ;)

You are amazing!

@LeilaGharani

6 жыл бұрын

I'm glad you like the video. I'm just the messenger though - Bart & Mehdi were the ones that came up with all the ideas.

Bundle of Thanks Mam Nice Topic & Nice Video

@LeilaGharani

6 жыл бұрын

You're very welcome Khalid. Thank you for dropping by.

Neat example of a step chart using error bars!

@LeilaGharani

6 жыл бұрын

Thank you Doug.

Very good vídeo!!!!

@LeilaGharani

6 жыл бұрын

Thank you for your support!

excellent

thumbs-up to the both of you..

@LeilaGharani

6 жыл бұрын

Thank you Joe! Thanks for your support.

Wallahi I have subscribed almost 100 ( KZread channels ) But I love your chart presentation more than any Excel expert

@LeilaGharani

6 жыл бұрын

That's really kind! Thank you! I'm very happy to hear you like the chart videos.

very good

Amazing

awesome Thank alot

@LeilaGharani

6 жыл бұрын

Thank you & your're very welcome.

Woww nice.... I have learned a new thing

@LeilaGharani

6 жыл бұрын

Glad to hear that!

super!

Awesome!0I am a big fun for the step chart, would u please post a video to how to combine step chart with column chart. I saw someone did it that was a mind blowing.BTW huge thanks for your excel sharing, i watched your first video from the latest one that meaned a lot to me.:)

thanks thanks thanks

Cute tutor...

As I'v been watcing every video, as civil engineer, usggest me how tp prepare related charts & cost preparation

Thanks Leila :)

@LeilaGharani

6 жыл бұрын

You're very welcome John. Do you use charts in your reports or formulas only?

@johnborg5419

6 жыл бұрын

I do use charts and your videos are very interesting to me, not only to use but to learn more and more. I love excel as you might have noticed already. Mostly I use Formulas, and the more complicated the scenario is, the more fun I get. I have been following Mike for Years and Aladin, Bill Szyisz and many more. Thanks to people like you and Mike we followers get better and better. God Bless you Leila :) :)

Good day. thank you very much for your effort. we are waiting to have the downloadable workbook !

@LeilaGharani

6 жыл бұрын

Thanks for reminding me! I'm at a seminar today, but I'll upload it right after.

@LeilaGharani

6 жыл бұрын

The Excel file is now available here: www.xelplus.com/how-to-create-step-chart-in-excel/ - just scroll down and download the file. Have fun :)

@abdsab78

6 жыл бұрын

Thank you very much. i highly appreciate it :-)

@LeilaGharani

6 жыл бұрын

You're welcome. Thanks for reminding me.

Awesome Leila! Thanks for this useful video. 🥰 Just a tiny comment; the currency is EUR in table, but in step-chart, you select USD instead of EUR. P.S: I’m in love watching your videos about Excel tips and skills. A huge thanks for your kindness. 👍 Best regards, Sothearith

@LeilaGharani

4 жыл бұрын

Thanks for the feedback Sothearith!

@SothearithKONGMrMuyKhmer

4 жыл бұрын

Leila Gharani You’re very welcome!

V. Good like it most. 👍Who noticed the tiny mistake of currency between y axis and the data inside the chart, $ and €?

@LeilaGharani

4 жыл бұрын

You got me there :)

Thank you. Is there any way to shade the area under the curve?

@LeilaGharani

6 жыл бұрын

You're welcome - I have to think about that.....

I added some cosmetic to your Awesome graph. And I have sent a mail.hope you have received it.

my princess...

Can you tell if the Row(PrTable[[#Headers],[Date]]) is always 0? Also can you tell why A12-A11=-43288?

@LeilaGharani

6 жыл бұрын

The row formulas gives the row the header is sitting in. If you deduct the previous row, you start from 1. Regarding the huge difference: if you go to cell A11 and change the cell formatting to general, you see 43288. That's how dates look as whole numbers. The value is the number of days since Jan 01 1900. So if we deduct zero from A11, we get -43288. It shows it to us as a number and not a date, because it has -ve in front of it....

Rather than =IF(DATE how about =MAX(0, to eliminate the negative day counter in the last row

@TSSC

4 жыл бұрын

Or, if the last price plotted is the current price: use today() in the formula to calculate the date difference (length of the horizontal error bar).

Have a suggestion for u make a video short length and to the point, u can check MJ tube channel he also make video on excel in short and simple way, don't mind take it as compliment

@elnurganbarov6502

6 жыл бұрын

it is ok some people like this style , so if you have suggestion do your own videos

Hi Leila.. could you please help me with heat map? What is heat map actually ?? And where we need to use it?

@LeilaGharani

6 жыл бұрын

Hi Balaji - here you can get a good overview: trumpexcel.com/heat-map-excel/ and here too which is on an actual map: support.office.com/en-us/article/show-a-heat-map-in-3d-maps-be0bad76-3f04-4e9b-8a53-1801fc2b17d9

@balajisuriyanarayanan6545

6 жыл бұрын

Leila Gharani wow.. thats cool.. thank you

Hey there

@abdallah.kandiel

6 жыл бұрын

I was waiting from morning Happy come back I will warch frist then continue annoying you 😅😅😅😅

@LeilaGharani

6 жыл бұрын

Hi there! This one took a lot longer to edit... Thank for watching & waiting :)

@abdallah.kandiel

6 жыл бұрын

this is very tricky i appreciate ur time but it deserves . that way to show the changes in prices is very practical i do need it to impress work buddies it adds to my experience an techniques how can i thank u i am in a rush because of q1 - 2018 business review i will finish it and join u in vba meanwhile best rose from me

@LeilaGharani

6 жыл бұрын

Thank you. Yes, it's tricky but I agree, it's a nice chart to impress. Most people don't know about error bars...Good luck with business review. Hope all goes well!

Instead if ROW's formula, "=if(rows([Date]=(row([@Date])-row(PriceTable[[#Headers],[Date]]),0,A5-[@Date]))" ----------- why cant we use "=IF(A5-[@Date]

Does anyone else have a problem with substraction of the dates... I get #Value for some reason. Any ideas? Thanks!

@LeilaGharani

6 жыл бұрын

Does Excel recognize the dates as real dates? If you go to home, and from the number field drop down, do you see date as the number formatting option?

@plamenfilipov4697

6 жыл бұрын

Thank you Leila! Yes I can see a few date options. Yet, there is date, short date, long date. Regardless of which one I pick it does not get the substraction! Keep up with the good work!

@LeilaGharani

6 жыл бұрын

If it's recognized as dates, you should be able to subtract.... that's strange that you get #value - you might get a date back which you can format as general and then see the number.... what if you write =today() in one cell and then in the next one write =today()+2 - in another cell subtract these 2 cells....?

@plamenfilipov4697

6 жыл бұрын

Yes, I figured it out! My excel recognized dates in the format 16.5.2018. Thanks again!

@LeilaGharani

6 жыл бұрын

That's great! Thanks for the feedback.

thx , jus one favours could u plz go slowly

I love You. You’re so cute.

Your vlogs are difficult.