Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts)

[@LeilaGharani]

Create charts that wow your audience. Learn the secrets now-start today! 👉 link.xelplus.com/yt-bizcharts-course Grab the file I used in the video from here: pages.xelplus.com/charts-max-min-file

[@edwardkeyaazenga6700]

Thank God I found Leila, watching your videos is massively improving my skills as an analyst big time!! Thank you so much!

[@LeilaGharani]

I'm really glad to hear that Edward!

[@rina2012ful]

Oh wow! I feel I am the Excel-genius after watching this. 😁Thanks Leila!

[@martarutkowska9170]

Leila, you are the best teacher! Great trick as usual!

[@Lunatyk001]

I am using exactly the same technique for forecast vs sale charts to display if forecast was accurate (thanks to two extra columns, first with values if forecast = +/- X% of sale - which means it's accurate, second column with values if first column contains error). I think that it is funny thing, that some time ago, after watching your other video ("This Excel Chart will grab your attention") I had a little fun and figured how to do this "trick" to conniditionally formate some values on chart, and now you are sharing exactly what i have figured form these video. :) Anyway, this video is much easier to adapt than previous for most people, so thanks for sharing it! It's much better to send link to video and let someone to learn something by himself (with possibility to watch video again everytime he needs it), than explaining how to do it every time he needs to highlight somehting on his new chart.

[@LeilaGharani]

I‘m glad to hear you‘ve done a set of experiments and testing from your side after watching the other video. Thanks for continuing to watch and recommending the tutorials here :)

[@wayneedmondson1065]

Hi Leila.. love this video and technique of adding additional data series and using NA() to isolate just the min/max to get the desired effect. Also, your chart enhancements are so creative and for those of us with no right brain skills, the lessons are invaluable for getting more impact out of the the results than just the standard defaults. Judging from the number of thumbs up on this video already.. more than 600 in less than 24 hours since you posted.. you have a lot of fans.. myself included. Keep them coming. Thanks and thumbs up!!

[@LeilaGharani]

Thank you Wayne. I've always been a fan of dynamic charts specially for reports that need to be produced on a consistent basis - it saves so much time and potential mistakes. Thank you for the thumbs up, comment and following the tutorials here on the channel. I really appreciate it!

[@antoniobacic5674]

Such intelligent solutions. Such beautiful end result. I’m loving it.

[@brianxyz]

You managed to show a lot in just 8:38 but did it so clearly. Great job!

[@LeilaGharani]

Thank you! I'm glad you like the video.

[@alaoibukun8223]

Thank you Leila for this video. You really saved me a lot of stress.

[@ChristianAndreassen]

Gold medal - to the point and very well delivered yet again!

[@LeilaGharani]

Thank you for the gold medal :)

[@paulozagatto6728]

Leila, I love your videos. You are super fantastic! For this wonderful chart, I would just add something else. In case you have more than one max or min values, you should get rid of a line that appears. So, you should select the series max, under Color select Line instead of Marker, then select No line. Do the same for series min. Thank you so much for sharing you knowledge with us. Greetings from Brazil!

[@shipingli7590]

You always bring something useful. Thank you very much.

[@saikrishnakanthprasad4494]

You are simply awesome in the way you teach Excel!!!!

[@tkosse]

A great explanation and a handy tool. Thanks Leila.

[@LeilaGharani]

Thank you Tom. I'm glad you like it.

[@yupi166]

very well explained! as always very well

[@soulmanjerome07]

Wonderful. It helped me adjust my data and show data points.

[@craigvoss1468]

Thank you for always sharing your abilities and knowledge with us.

[@pusun7087]

couldn't have been any more magical!!!!

[@abdullahiqbal5996]

Thank you, for everything you do... you are "The Best"...

[@NikeTao]

Thanks, worked like a charm!

[@irwankurniawan1737]

Useful tips. Thank you!

[@SabongHobbyist01]

You're a gem!

[@meongcaem5802]

Thank you Leila... you gave another great tutorial for my self development...

[@lakshmipathiganesan6332]

Excellent and thanks for sharing such informative tips

[@simdog635]

Brilliant, very clean graph and taught perfectly, thanks

[@ayeshan7767]

Thanks Leila.. you are amazing.. !! Came across ur channel today was great learning .. !!

[@monte4955]

Great tips Leila as always. Thanks for sharing. I will definately use this.

[@LeilaGharani]

Great! I'm glad to hear that.

[@ΕλευθερίαΚυριαζή-ψ9ο]

Leila this is extremely helpful. Thanks🙏

[@barryh7387]

Excellent as always thanks

[@z058261]

learnt this today! Awesome

[@amarqueze]

Hi Leina ... smart and easy way out to create this nice chart!!! I`m looking your videos for long time and they are really handy and help me a lot. Thanks for sharing these amazing tricks. In retribution I`d like to share one smart trick that I don`t often see you using, and see you struggling to align charts properly. If you hold ALT key while dragging the handles of a chart you will snap them to the cells. It makes much easier to adjust it`s dimensions, specially if you have 2 charts to be fully aligned. You can make them same size just snapping to the cells grid.

[@LeilaGharani]

Thank you Adriano and also for the wonderful tip. I keep forgetting about the ALT key and go about it the long way. Thanks for sharing and for your support.

[@entertainmentgalaxy971]

Wow. another masterpiece from Leila. Thanks for sharing.

[@LeilaGharani]

You're welcome Haider. Thanks for watching.

[@mrsmrk0771]

Another one great video. Really helpful 👍 . Thank you so much !

[@LeilaGharani]

You're very welcome Mirko! Glad you like it :)

[@NeerajPareek1975]

Thanks! Leila, for the wonderful topic. You are awesome in explaining, specially your accent. Have seen other videos where you hardly understand, but in your case, just one thing, Fantastic. Request you to cover "DGET" function in future videos.

[@17aig]

As always great presentation thank you very much

[@sandipballav]

Great, thank you for sharing and educating us.

[@shakilshaikh1325]

Thanks a lot.... May God bless you.. As gained a lot knowledge due to your efforts.

[@LeilaGharani]

Thank you for watching and supporting.

[@asankawijesinghe6977]

very simple and understandable. thank you

[@wesleylim3871]

I really like all your videos. You're amazing. I can apply this on my reports.

[@LeilaGharani]

Thank you for your comment & thumbs up!

[@manojrbca]

Very useful video. Thanks a lot

[@1wnnn]

This will help a lot. Thank you.

[@subratadutta4562]

Excellent, explained very clearly. Will definitely help lot of people including me. Thanks Mam

[@vivekjain8958]

Thanks .. great help .. I needed multiple points so improvised a bit by using rank

[@gauravjaiswal5703]

Thank you, it is really worth it to watch and learn.

[@bindur1765]

Blessings 😊of joy to you 🙂Genius 👍💐

[@arunark274]

👍👍👍👍 you always bring something exciting. Love all your videos. Learnt alot and used extensively in my work with all possible wow factor 💕💕💕💕💕👍👍👍👍🎉🎉🎉🎉💐💐💐💐

[@mmuhanda]

Wow very creative and informative

[@zeeshansami4210]

Really helpful, thank you

[@mando388]

Thank you so much, realy i use your lesons in my work and i built many programes by excel that helping me too much in my work

[@emmanuelle8032]

Amazingly helpful ! wow!

[@mihaicadis6502]

You are the best!

[@مقدادحديد]

Excel is always sweeter with Queen Leila

[@yulinliu850]

Thanks Leila! Great video!

[@LeilaGharani]

Thank you Yulin! I'm glad you like it.

[@vida1719]

Great as always

[@reach2sravankumar]

Super Thought...Loved it...Waitingbfor more

[@reach2sravankumar]

Wow am so happy...you read my comment.... you made my day...Every day I keep looking for ur videos...😍

[@chipturner495]

Nice! I like using dynamic formatting wherever possible.

[@ursvenky6394]

Beautiful lady came up with beautiful trick. 😍😍😍😍 Thanks Leila

[@XavierFsc]

Thank you, for this explanation.

[@sarfarajkureshi6569]

Smart Way to create chart nice mam god bless you

[@ckokse]

Very nice. I already have a graph in mind at work where I can implement this. Thank you!

[@antonarbus]

это же гениально!

[@peternganga9371]

As usual, PERFECT. Thanks.

[@ibrahimsalims3612]

Thank u for sharing 😘

[@whatsupdown4181]

Thank u so much for your courses

[@M.A.Sammani]

Thank you so much.

[@fadijoria6233]

Very nice idea

[@StePhanMckillen]

Nice that thinking out side the square

[@TUbeCesar1972]

Thanks a lot I Love You since always!

[@hmghmgforum4688]

Good one, as usual.

[@RahulJauhari]

Thanks great work

[@SolidSnake59]

This is great! Thanks a lot!

[@saraouldhamouda6586]

Great video, thank you for shearing:)

[@dashrathpanchal8393]

Great trick

[@stefanbotha7451]

Thanks Leila.

[@LeilaGharani]

You're welcome Stefan. Thanks for watching.

[@excellearning6981]

Thank you so much

[@hazemali382]

great video

[@whatsupdown4181]

Really appreciated

[@LeilaGharani]

I appreciate your support Smail.

[@rudi-gruber]

Again, thus ist really cool. great Video Thx

[@gazda1981]

Great job

[@MdIlyasShaikh]

Nice tricks.

[@Quantumvibes110]

Very much helpful, thank you :)

[@WaqasAli-dq9wg]

Thanks.....Instructor for helping me out a bit

[@luisneto2165]

Amazing! Thanks.

[@johnborg6005]

Thanks Leila :) :) Very Helpful

[@arulthangavelu3639]

Great Video. Thank you Madam

[@heshamallam5597]

This is great.. Thanks a lot!

[@robertakwasiadjei8223]

Thanks Leila

[@werachaisrisupinanont3353]

Cool technic

[@juanjajan7243]

Thanks a lot

[@LeilaGharani]

My pleasure.

[@shanesmohammed]

Mind blowing!!!

[@elfridhasman4181]

Love itt❤️❤️

[@hattan6775]

Really you are awesome 👏😍

[@mohamedharoon3750]

Thank you.

[@deepakpatel4186]

Superb

[@ricos1497]

Your graph videos are phenomenal. I had seen the NA() usage before, but completely forgot about it. One thing did surprise me though: your use of groupings in Excel. You strike me as someone who is - like me - a little obssessed about screen "real estate". I hate the amount of space that grouping takes up, it's just really inefficient. I tend to either use one of the location pin in excel's Icons or the "Rectangle with top corners rounded" shape as a tab, attaching a macro to quickly hide or unhide the desired columns (in your case Range("C:D").EntireColumn.Hidden = Not Range("C:D").EntireColumn.Hidden). Obviously that wasn't the purpose of your video, but I just thought I'd mention it. I'd love it if Excel made it's groupings more in line with small + symbols they provide on pivot tables which are far cleaner. Anyway, rant over! Thanks for another great video.

[@LeilaGharani]

Hi Rico - Yes, attaching a macro to hide and unhide is a good idea. The grouping does take up too much space - Just hiding without any indication can also be misleading if you're sharing files with others. The macro is a good idea, specially with the button so people know there is something hidden. Thank you for your comment.

[@ricos1497]

@@LeilaGharani Yes, I agree, sharing files without indication would be an issue, and also having a macro enabled file might also cause an issue that just grouping wouldn't. I'd love it if microsoft re-visited the grouping labels and made them a bit neater. They seem to have made everything else on the interface that bit nicer these days, but perhaps forgotten about the lonely grouping function!

[@zouheirkhiari8129]

Merci Leila, extra

[@keishrich]

Another top notch tip. Thank you! If you're hiring please let me know, I would love to work for you.

[@LeilaGharani]

You're welcome Keisha. Make sure you're part of my newsletter. We might be hiring some time in the future.

[@jimmichels2573]

Great method to show max and min data points!!! What versions of Excel can this method be used with.

[@LeilaGharani]

All versions - it works on Excel 2007 as well as 2019.

[@robiulhoque5032]

Excellent

[@OPDibyan]

Good Trick to showing min & max value in chart. Can you explain why max & min lines is disappeared after na() function used? Thank you