Omg after three years of viewing all kinds of RUclips sourced studying video, your videos which for whatever reasons RUclips 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. 你是我的女神！
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).
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.
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.
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 😂
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
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.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Grab the file I used in the video from here 👉 pages.xelplus.com/variance-chart-file
Leila will always my thumbs up cause she is simply the best ,no controversy . Learnt cool stuff from you
Thank you 😊
Omg after three years of viewing all kinds of RUclips sourced studying video, your videos which for whatever reasons RUclips 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. 你是我的女神！
Super cool trick especially the label format tip, that was new to me. Thanks for sharing!
I just wanted to say Choukrane thank you for all what are you doing :) :) :)
Our pleasure!
You continue to be the best Leila , totally appreciated
You're most welcome. Many thanks for your ongoing support of my channel.
Smart yet simple, as usual. You're the best :)
Thanks Dmitry. Glad you like it.
Big help to me. You are unbelievably amazing.
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).
That's smart Enny :) thanks for sharing!
Well explained Leila & very useful👍👍
Thank you. Glad you like it.
It is something new to me. Thanks for your excellent way of explanation.
This is very useful. Thanks
U provide grt knowledge...
excellent !!! I must try this
Great video Leila very fun chart
Excel is a lot of fun :)
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.
Excellent tricks. I like your channel 🌹
Good job lady!!!
Thanks for your orijinal techniques
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.
eres la mejor 😎, te amo 😍...
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.
Superb. you solved my problem.
additional knowledge. Thanks a lot Miss Leila ;)
You're very welcome Joey.
This is amazing!
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 😂
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
Fantastic, just used it for my report to the board of a NFP I help
That's great :)
Hey Leila, so the option for invert chart would not be available here like it was in the previous video, for negative values??
Good topic choice!
Thanks for the efforts, it's very useful.
Glad you like it.
which software you use to make your videos effective?
I use Camtasia.
That does look neater than the bar chart version.
Amazing
thanks
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.
If you mean the custom formatting for the percentage with red and green - you can can it here: ruclips.net/video/A3NfEkf8S0o/видео.html
How
Awesome
Very helpful
Great :)
excellent
Glad you like it Tracy.
Thank you !!
You're very welcome.
Excellent! I Will use it to show difference betwen budget and effective for each month! Maybe I win a promotion 😀
Great! Fingers crossed for that promotion :)
Helpful good one LG
What is new for 2019
I am waiting a lot
Thanks Dev. There were two new videos in 2019 :)
Hi how to hide the 0%
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/
Hello hai mam how r you mam show me MS Access video plz
HI Mohammad, I don't really use MS Access except to get data from it once in a while for Excel...
I admit it is a fantastic work, but it will consume too much time and no one will appreciate my effort
I didn't learn anything, I got distracted.