Grab the file I used in the video from here 👉 pages.xelplus.com/variance-chart-file
@megaiang81336 жыл бұрын
Omg after three years of viewing all kinds of KZbin sourced studying video, your videos which for whatever reasons KZbin pushed to me this morning, are simply the best. Period. The video making is elegant, informative and beautiful.just beautiful. You explanation and voice is first class too. I really want to worship you and thank you for making and sharing your knowledge. 你是我的女神!
@xeroxo72103 жыл бұрын
Leila will always my thumbs up cause she is simply the best ,no controversy . Learnt cool stuff from you
@LeilaGharani3 жыл бұрын
Thank you 😊
@SpotlightImpact2 жыл бұрын
Super cool trick especially the label format tip, that was new to me. Thanks for sharing!
@ennykraft7 жыл бұрын
Very interesting! I like the skinny bars. After playing around with it for a while, I had this idea of achieving the same look with a regular bar chart. I drew a larger rectangle with no fill and no outline. Then I drew a second rectangle inside that one with the same height but much narrower. Then I selected both, copied them to the clipboard and pasted them into the bars (same technique you used in the video with the bars that are rounded on top).
@LeilaGharani7 жыл бұрын
That's smart Enny :) thanks for sharing!
@tooliste313 жыл бұрын
I just wanted to say Choukrane thank you for all what are you doing :) :) :)
@LeilaGharani3 жыл бұрын
Our pleasure!
@mohammadhammoud53215 жыл бұрын
You continue to be the best Leila , totally appreciated
@LeilaGharani5 жыл бұрын
You're most welcome. Many thanks for your ongoing support of my channel.
@yschen8883 жыл бұрын
Big help to me. You are unbelievably amazing.
@AmitSharma-ft7jb2 жыл бұрын
U provide grt knowledge...
@jaredfromtexas74845 жыл бұрын
Microsoft needs to set up the "Gap Width" option so that a user can make the graph’s columns as thin as they want. Another work-around for making the columns thin is that for the cells that contain the data, add several blank rows between each. This forces the chart to have several extra columns between the real columns, but these in between don’t show up. This is able to force the graph’s actual columns to appear thinner. But I don’t know if this method is any better/easier overall than the error bar method you’ve shown here.
@inezwong2515 Жыл бұрын
This is very useful. Thanks
@erdalorals2 жыл бұрын
Thanks for your orijinal techniques
@DmitryWhite827 жыл бұрын
Smart yet simple, as usual. You're the best :)
@LeilaGharani7 жыл бұрын
Thanks Dmitry. Glad you like it.
@MyRobin383 жыл бұрын
excellent !!! I must try this
@saravanakumarkaliaperumal83155 жыл бұрын
It is something new to me. Thanks for your excellent way of explanation.
@woodypham64744 жыл бұрын
Good job lady!!!
@3DPRINTechnology5 жыл бұрын
Superb. you solved my problem.
@xlvista72455 жыл бұрын
Ur great and having incredible skills. I want to be like u skillful, I know, I can't, but want to get more knowledge. I am mis analyst also having knowledge of VBA.
@manimarankrishnan41096 жыл бұрын
Well explained Leila & very useful👍👍
@LeilaGharani6 жыл бұрын
Thank you. Glad you like it.
@nikesh4215 жыл бұрын
Hi Leila, I am a great fan of your videos where I try to innovate some task and analysis that I perform at work. The Percentage change Chart you created is great. I just wanted to suggest if you can create a similar % change chart within one combo chart using scatter plotline. Is that something you can create? Thank you
@mehrabganjali16446 жыл бұрын
Excellent tricks. I like your channel 🌹
@mohamedchakroun49737 жыл бұрын
Great video Leila very fun chart
@LeilaGharani7 жыл бұрын
Excel is a lot of fun :)
@hosseinhosseinpoor48453 жыл бұрын
thanks
@JD21O6 жыл бұрын
eres la mejor 😎, te amo 😍...
@karencrouch56715 жыл бұрын
Fantastic, just used it for my report to the board of a NFP I help
@LeilaGharani5 жыл бұрын
That's great :)
@jasonipfatsiong20623 жыл бұрын
Amazing
@nattawut_chatwiriyacharoen4 жыл бұрын
Please feel free to correct me if I'm wrong. It's better to use a simple line chart instead of the Scatter XY. We have no need to worry about X and Y.
@kalaiarasan698 Жыл бұрын
Awesome
@noel11114 жыл бұрын
This is amazing!
@diannedrechsler47926 жыл бұрын
That does look neater than the bar chart version.
@ordinaryo24297 жыл бұрын
additional knowledge. Thanks a lot Miss Leila ;)
@LeilaGharani7 жыл бұрын
You're very welcome Joey.
@JV-xg5jk5 жыл бұрын
Hey Leila, so the option for invert chart would not be available here like it was in the previous video, for negative values??
@quasipseudo17 жыл бұрын
Good topic choice!
@LotfyKozman7 жыл бұрын
Thanks for the efforts, it's very useful.
@LeilaGharani7 жыл бұрын
Glad you like it.
@ytforum7 жыл бұрын
which software you use to make your videos effective?
@LeilaGharani7 жыл бұрын
I use Camtasia.
@orangefly32637 жыл бұрын
excellent
@LeilaGharani7 жыл бұрын
Glad you like it Tracy.
@ALPHERATZ36506 жыл бұрын
Leila would you be so very kind to show the percentual format you have used in this chart? I tried to applied it to my chart but I still have labels with zeors.
@LeilaGharani6 жыл бұрын
If you mean the custom formatting for the percentage with red and green - you can can it here: kzbin.info/www/bejne/d2Sxl3ihm52GZtE
@MrLokman675 жыл бұрын
How
@tomtom89957 ай бұрын
Fantastic graph but there were gaps between the points on the x axis. Couldn’t work out what went wrong. Had a insert a straight line along the x axis so to cover the gaps 😂
@alexrosen87627 жыл бұрын
Very helpful
@LeilaGharani7 жыл бұрын
Great :)
@Dev_Bartwal5 жыл бұрын
Helpful good one LG What is new for 2019 I am waiting a lot
@LeilaGharani5 жыл бұрын
Thanks Dev. There were two new videos in 2019 :)
@fernandoguerald22867 жыл бұрын
Excellent! I Will use it to show difference betwen budget and effective for each month! Maybe I win a promotion 😀
@LeilaGharani7 жыл бұрын
Great! Fingers crossed for that promotion :)
@automationguide34987 жыл бұрын
Thank you !!
@LeilaGharani7 жыл бұрын
You're very welcome.
@MrLokman675 жыл бұрын
Hi how to hide the 0%
@LeilaGharani5 жыл бұрын
You can update the cell formatting to be #.0%;-#.0%;; Check out this post to find out more: www.xelplus.com/excel-custom-number-formatting_1/
@mohammadasad98907 жыл бұрын
Hello hai mam how r you mam show me MS Access video plz
@LeilaGharani7 жыл бұрын
HI Mohammad, I don't really use MS Access except to get data from it once in a while for Excel...
@alishots2 жыл бұрын
I admit it is a fantastic work, but it will consume too much time and no one will appreciate my effort