Love the way you present ways to take Excel to the next level. I like downloading your sample spreadsheet. I attach the link to the video so I can play it over so I can do it from memory. Thanks so much for your expertise!!! Extremely informative!!!
Clever … so very clever ... but most importantly, so quickly informative. Sidebar Comment Every week I marvel at the simple but effective presentations … like watching an Olympic figure skater easily gliding around the rink effortlessly executing one jump after another (or for the three 'older' viewers … like watching the American actress/dancer Ginger Rogers (from the 1930's) dancing w/Fred Astaire … flawless.
It's always exciting to watch these videos... It's so instructive and concise at the same time. I can't wait for the next video. Thank you for sharing your knowledge, Ms. Leila.
Fantastic. I love your chart videos. One of a few on youtube that concentrate on formatting/presentation and clarity, which seems to get lost on many tutorials, but is vital. Most of my data is Data Model derived these days in an attempt to make it more dynamic, but I'll definitely apply this technique to the pivot chart as opposed to the normal chart (I wish the two were completely aligned). Great work!
Hi Leila.. AWESOME!! These tips really supercharge the chart creation process! Invert if negative, Copy and Paste Special Formats, Object Grouping, etc. All super valuable! Thanks for sharing them :)) Thumbs up!!
Oh Leila....no words to express my thanks ...this is exactly what i was trying to do for quite some time........thanks from the core of my 💓..........you are really a life savior......
Hello Leila, Thanks a million for all of your brilliant videos. I have learnt a great deal from you. One thing is I notice in this video there is a lot of low frequency bonk bonk bonk sound when you type or bump the desk surface. I am a sound engineer and suggest that you place a low pass cut filter in your audio signal chain, some mixing desks have a LOW CUT button, otherwise you could try turning the bass down. Anything below 100 Hz or 200 Hz you would be best getting rid of. The other thing I have to thank you for is that you don't have annoying music in the background. Well done! 🙂
Hi Leila, This trick is so powerful and useful in order to show maks and min. values into a Chart. I learned this technique from your previous lectures and applied in my reports very successful. You are so miracle Leila 🙌. I love you✨
Hi Leila, that's beautiful in its simplicity and as the third google result for my query on that exact issue I was lucky to click on it first and have the patience to watch the video (I tend to judge things too quickly and thereby miss out!), simple is best, thank you once more:)
Good video, some useful tips there! Conditional formatting on charts can be achieved using a little VBA. I have a simple piece of code which loops through all data points in all series in a chart and colours them green, orange or red based on their value. Happy to share if others would find this useful.
@@rizbfatango Not sure how the code will work in a TH-cam comment but i'll try. I also use the method above for 2 (and 3) different colours of smaller data sets. But one chart I was tracking hourly recordings for a month and so this resulted in 744 datapoints - creating 3 different series to accomodate the above approach just wasn't practical, so i used the code below Sub ChangeChartColours() Dim cht As Chart, s As Series, p As Point Dim vals, i, x As Integer
Set cht = ActiveChart
On Error Resume Next
For i = 1 To 31 '31 as there is up to 31 days in a month
Set s = cht.SeriesCollection(i)
vals = s.Values
For x = LBound(vals) To UBound(vals) If vals(x) > 100 Then With s.Points(x) .Format.Fill.ForeColor.RGB = RGB(255, 0, 0) 'Red End With ElseIf vals(x) > 30 Then With s.Points(x) .Format.Fill.ForeColor.RGB = RGB(237, 125, 49) 'Orange End With Else With s.Points(x) .Format.Fill.ForeColor.RGB = RGB(112, 173, 71) 'Green End With End If Next x Next i Set cht = Nothing Set s = Nothing End Sub
Hi Leila, thanks for your awesome tutorials, which are simply the best out there. I am currently struggeling with a competition analysis and hope that you have a solution for the following scenario. I have to make sure, that each competitor is always displayed with the assigned color in all graphs, e.g. IBM in Blue, Google in Green, Microsoft in Orange etc. It‘s really awkward to manually assign it to all graphs over and over again. Thanks in advance for your help and looking forward to hearing from you.
cool nostalgia effect from Udemy class, but I do miss your waterfall graph chart. It was pretty useful for my past project, and boss was impressed. till next week.
My company only use google sheets, I just apply the same techniques. I still shine at my job because of your tutorials. Thanks for another awesome one.
Grab the file I used in the video from here 👉 pages.xelplus.com/conditional-bar-chart-file
Seeing the copy chart format was worth the price of admission alone!!
Love the way you present ways to take Excel to the next level. I like downloading your sample spreadsheet. I attach the link to the video so I can play it over so I can do it from memory. Thanks so much for your expertise!!! Extremely informative!!!
Excellent as always. A big thank you for making you lessons available for EVERYONE.
I thought I knew a bit about charting, but this is light years ahead of me! Thanks Leila
Glad it was helpful!
You are the next level Excel Guru that I needed in my life, THANK YOU!
Im in love with the "invert if negative" graph format, thanks for the tips!
You're so welcome, Eduardo!
Another great tip! Thanks Leila! Learning a lot from your videos and looking forward eagerly for more!
Leila is an example of pedagogical prodigy ! great work
Amazing! I love your work so much. Thank you, Leila.
Really handy tip. I deal with a lot of chart data so this will come in handy. Thanks Leila
This example was really effective. You highlighted some useful features which will save me a lot of time. Thanks.
Thank you for your videos. I love learning new tips & tricks :)
What a fantastic video, Leila, thank you very much for this great tutorial !
Clever … so very clever ... but most importantly, so quickly informative.
Sidebar Comment
Every week I marvel at the simple but effective presentations … like watching an Olympic figure skater easily gliding around the rink effortlessly executing one jump after another (or for the three 'older' viewers … like watching the American actress/dancer Ginger Rogers (from the 1930's) dancing w/Fred Astaire … flawless.
Wow, thank you!
Thanks Leila. Thursday's are much better now knowing your video comes out. :)
Leila, You Are too good.What a lovely presentation , yet simple to understand. I am certainly going to use them in my presentation.
Thanks Leila, you really are the best!
It's always exciting to watch these videos... It's so instructive and concise at the same time. I can't wait for the next video. Thank you for sharing your knowledge, Ms. Leila.
Happy to hear that, Julius!
Yes i enjoyed these excel chart tricks. Thank you so much!
Fantastic. I love your chart videos. One of a few on youtube that concentrate on formatting/presentation and clarity, which seems to get lost on many tutorials, but is vital. Most of my data is Data Model derived these days in an attempt to make it more dynamic, but I'll definitely apply this technique to the pivot chart as opposed to the normal chart (I wish the two were completely aligned). Great work!
Glad you like them, Rico!
Great ideas and tricks as always, thanks for sharing!
Thank you for your explanation. Perfect!
I really enjoy your videos, very clear to the point. Thank you for sharing such informative videos.
Very useful tips and well presented as usual! Thanks for sharing Leila :)
Wow! This is real magic!
Great vid on Conditional Formatting for charting!
Irrespective of implementation, I always watch your videos like a daily bulletin. Simply cool 🎯 and thanks for sharing 🙌
My pleasure, I appreciate that!
Thanks Leila - this is just great!!
Thank you so much, huge fan of your work
Love your Excel chart tricks 👍
Hi Leila.. AWESOME!! These tips really supercharge the chart creation process! Invert if negative, Copy and Paste Special Formats, Object Grouping, etc. All super valuable! Thanks for sharing them :)) Thumbs up!!
Thank you, Wayne!
Thanks Leila! Nice to learn one more thing from you. Keep them coming!
More to come, Vladimir!
Wow! Wow!! Wow!!. Absolutely amazing tip Leila. Explanation is very lucid. Thanks a million for sharing 👏
You're so welcome!
Stunning!
Thanks, Teammate!
Thank you too, teammate!
Thank you Leila. You know your stuff!
Glad you think so!
Thanks Leila. That was Fun!! : )
Excelente muy buen video, muy profesional muchas gracias Leila
I felt in love 😍
Excellent, as usual. Thanks.
thank you easy to know , I like the way you simplify.
Thanks !! You are amazing
Great tric to have thank you Leila...👍🏻
You are great. Thanks, i'll apply it in my next videos.
Oh Leila....no words to express my thanks ...this is exactly what i was trying to do for quite some time........thanks from the core of my 💓..........you are really a life savior......
My pleasure 😊
This is something I never believe can be done in Excel. Leila you are awesome!!!!
Thank you!
Thank you so much for the great trick of Charts..
Thanks Leila it is a valuable information!
Awesome tip!
Hello Leila, Thanks a million for all of your brilliant videos. I have learnt a great deal from you. One thing is I notice in this video there is a lot of low frequency bonk bonk bonk sound when you type or bump the desk surface. I am a sound engineer and suggest that you place a low pass cut filter in your audio signal chain, some mixing desks have a LOW CUT button, otherwise you could try turning the bass down. Anything below 100 Hz or 200 Hz you would be best getting rid of. The other thing I have to thank you for is that you don't have annoying music in the background. Well done! 🙂
Really very nice bar chart trick . I m gonna use this in my bar chart. Thank you Leila
Just brilliant one word
Leila, I just finished your course on Power Query. I felt like it was tailored made for me. It was that good. Thanks, Mark
Wonderful! Glad it was helpful, Mark.
Again thank you!!
Very cool, and you are an excellent teacher.
You are awesome!!!!
Thanks. This is helpful.
Excellent!!
Too good. Fabulous
Very nice trick, i've been searching for it for quite a long time.
Thanks for the great and unique content as always.
Happy to help
You are a genius.
This is awesome!
Got it thank you Leila making life easy
Thank you!
Another great video Leila. Thank you always
My pleasure!
Hi Leila,
This trick is so powerful and useful in order to show maks and min. values into a Chart. I learned this technique from your previous lectures and applied in my reports very successful.
You are so miracle Leila 🙌. I love you✨
Thanks Emre!
Really helpful. This channel helped me a lot, Thank you Leila Gharani
Thank you very much.
Hi Leila!Really Impressive Helpful Tips..Thank You :)
Hi Leila, that's beautiful in its simplicity and as the third google result for my query on that exact issue I was lucky to click on it first and have the patience to watch the video (I tend to judge things too quickly and thereby miss out!), simple is best, thank you once more:)
Glad it was helpful, Mark!
Incredible, Excel Wizard! Liked and subscribed right away.
Welcome aboard!
Once again a great video. Thanks Leila 🙏
Thank you! 😃
Thanks a lot Leila..👏
Bravísimo!
Greetings from your #1 fan in México 😄
Yay! Thank you!
Very cool tip Leila, thanks!
My pleasure, Chris!
Thank you so much!! I've been trying to do this for ages... you have a new sub :)
Great! Welcome aboard!
Explanation is precise and so well presented. Thank you so much!
Awesome!
Great. Thank you
Your videos are mind blowing! Very good! 📊
Wow, thanks!
Thank you, it's new topic learn
Wow, this was a fantastic presentation. I will definitely be applying this to my reports. Thank you so much
You're very welcome!
Thank you so much , I love your vedios .....
Awesome as usual 😊😊😊
Couldn't have done it better myself!
Thank you, Jon.
Easy to follow.
Hah! Thanks for idea how to make better my Tuesday report :) Tomorrow I will add
Good video, some useful tips there!
Conditional formatting on charts can be achieved using a little VBA. I have a simple piece of code which loops through all data points in all series in a chart and colours them green, orange or red based on their value. Happy to share if others would find this useful.
Can you please share. I'm working on a data set where I need to color the 3 bottom values of data. Thank you
@@rizbfatango Not sure how the code will work in a TH-cam comment but i'll try. I also use the method above for 2 (and 3) different colours of smaller data sets. But one chart I was tracking hourly recordings for a month and so this resulted in 744 datapoints - creating 3 different series to accomodate the above approach just wasn't practical, so i used the code below
Sub ChangeChartColours()
Dim cht As Chart, s As Series, p As Point
Dim vals, i, x As Integer
Set cht = ActiveChart
On Error Resume Next
For i = 1 To 31 '31 as there is up to 31 days in a month
Set s = cht.SeriesCollection(i)
vals = s.Values
For x = LBound(vals) To UBound(vals)
If vals(x) > 100 Then
With s.Points(x)
.Format.Fill.ForeColor.RGB = RGB(255, 0, 0) 'Red
End With
ElseIf vals(x) > 30 Then
With s.Points(x)
.Format.Fill.ForeColor.RGB = RGB(237, 125, 49) 'Orange
End With
Else
With s.Points(x)
.Format.Fill.ForeColor.RGB = RGB(112, 173, 71) 'Green
End With
End If
Next x
Next i
Set cht = Nothing
Set s = Nothing
End Sub
Great video :)
Hi Leila, thanks for your awesome tutorials, which are simply the best out there. I am currently struggeling with a competition analysis and hope that you have a solution for the following scenario. I have to make sure, that each competitor is always displayed with the assigned color in all graphs, e.g. IBM in Blue, Google in Green, Microsoft in Orange etc. It‘s really awkward to manually assign it to all graphs over and over again. Thanks in advance for your help and looking forward to hearing from you.
Thanks a lot, your voice like a music to ears. Your fan from Turkmenistan.
Another great tutorial thanks a lot
My pleasure!
cool nostalgia effect from Udemy class, but I do miss your waterfall graph chart. It was pretty useful for my past project, and boss was impressed. till next week.
Very very good.
Its amazing
My company only use google sheets, I just apply the same techniques. I still shine at my job because of your tutorials. Thanks for another awesome one.
Thank you
Beautiful
V. good thanks
Good logic ill do it in percentage instead hope my idea works :)