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

@LeilaGharani

4 жыл бұрын

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!

@LeilaGharani

4 жыл бұрын

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.

What a fantastic video, Leila, thank you very much for this great tutorial !

Thank you for your videos. I love learning new tips & tricks :)

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.

@LeilaGharani

4 жыл бұрын

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.

@LeilaGharani

4 жыл бұрын

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!

@LeilaGharani

4 жыл бұрын

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 🙌

@LeilaGharani

4 жыл бұрын

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

@LeilaGharani

4 жыл бұрын

Thank you, Wayne!

Thanks Leila! Nice to learn one more thing from you. Keep them coming!

@LeilaGharani

4 жыл бұрын

More to come, Vladimir!

Stunning!

Wow! Wow!! Wow!!. Absolutely amazing tip Leila. Explanation is very lucid. Thanks a million for sharing 👏

@LeilaGharani

4 жыл бұрын

You're so welcome!

Thanks, Teammate!

@LeilaGharani

4 жыл бұрын

Thank you too, teammate!

Thank you Leila. You know your stuff!

@LeilaGharani

4 жыл бұрын

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

@LeilaGharani

4 жыл бұрын

My pleasure 😊

This is something I never believe can be done in Excel. Leila you are awesome!!!!

@LeilaGharani

3 жыл бұрын

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

@LeilaGharani

4 жыл бұрын

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.

@LeilaGharani

4 жыл бұрын

Happy to help

This is awesome!

Got it thank you Leila making life easy

You are a genius.

Thank you!

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✨

@LeilaGharani

4 жыл бұрын

Thanks Emre!

Another great video Leila. Thank you always

@LeilaGharani

4 жыл бұрын

My pleasure!

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

@LeilaGharani

Жыл бұрын

Glad it was helpful, Mark!

Incredible, Excel Wizard! Liked and subscribed right away.

@LeilaGharani

3 жыл бұрын

Welcome aboard!

Thanks a lot Leila..👏

Once again a great video. Thanks Leila 🙏

@LeilaGharani

4 жыл бұрын

Thank you! 😃

Bravísimo! Greetings from your #1 fan in México 😄

@LeilaGharani

4 жыл бұрын

Yay! Thank you!

Very cool tip Leila, thanks!

@LeilaGharani

4 жыл бұрын

My pleasure, Chris!

Thank you so much!! I've been trying to do this for ages... you have a new sub :)

@LeilaGharani

3 жыл бұрын

Great! Welcome aboard!

@michellechong6667

3 жыл бұрын

Explanation is precise and so well presented. Thank you so much!

Awesome!

Great. Thank you

Your videos are mind blowing! Very good! 📊

@LeilaGharani

4 жыл бұрын

Wow, thanks!

Wow, this was a fantastic presentation. I will definitely be applying this to my reports. Thank you so much

@LeilaGharani

6 ай бұрын

You're very welcome!

Thank you, it's new topic learn

Thank you so much , I love your vedios .....

Awesome as usual 😊😊😊

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.

@rizbfatango

2 жыл бұрын

Can you please share. I'm working on a data set where I need to color the 3 bottom values of data. Thank you

@toomstube

2 жыл бұрын

@@rizbfatango Not sure how the code will work in a KZread 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

@LeilaGharani

4 жыл бұрын

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

So using this in my consulting presentations to clients!!

@LeilaGharani

4 жыл бұрын

Great! I hope they'll like it.