Comparison Chart For Dashboards... Simple and Beautiful

[@elenahicks2094]

I am blown away with how many things I just learned in under 30 minutes. You are not just a very talented excel guru but also a very gifted instructor. Thank you very much

[@Officeinstructor]

People like you Elena Hicks... Fuel my energy and inspire me to do more for the Excel community. It's ME who should be thanking YOU for the nice and motivating words.... Stay tuned: The Best Is Yet To Come

[@titan2793]

This chart is fantastic. Many of the comments below already stated how I feel about this tutorial. Thank you.

[@Up4Excel]

Great technique getting the coloured triangles and values above the chart. Looks good 👍 John

[@VIPULDJHAVERI]

Fascinating , this will help us all to add emotions to numbers , Thanks our Picasso !!!

[@Officeinstructor]

Thank you so much

[@karimredouane2150]

Thanks nabil the best to come...

[@Officeinstructor]

You are welcome

[@thakuranujsingh4419]

Very beautiful video and your teaching style, I'm your old fan thank u so much for teach us.

[@Officeinstructor]

Thanks and welcome

[@AnbarasuAnnamalai]

Good and it is nice to hear from you.

[@Officeinstructor]

Thank you for being a loyal follower

[@coachz7970]

Just amazing and easy to follow, Thank you Sir

[@Officeinstructor]

You are most welcome

[@ashwindesai4957]

Good tutorial..would love to see more from you 😊😊

[@deepakjhurani4840]

wow! this is one of the best comparison chart I have ever come across! btw, exercise file didn't have the graph, is there any way to get that?

[@IvanCortinas_ES]

Extrasensorial. Wonderful tutorial. Thank you Nabil!!!

[@RafiqulIslam-dv9cu]

Great idea to visualize the data for comparison

[@Officeinstructor]

Glad you liked it

[@ajdakam]

Great tutorial!!!

[@adriaq219]

Thank you!! It's eye catching chart. Very useful.

[@Officeinstructor]

You're very welcome!

[@17aig]

Mr. Nabil, you are the greatest what an amazing video thank you so much.

[@Officeinstructor]

Many many thanks

[@FAlsufyani]

Excellent work and very clear explanation. Keep it up

[@Officeinstructor]

Glad you liked it Fahad

[@SolomonKinyanjui_sk]

Wonderful chart 📊. Well explained.

[@Officeinstructor]

Glad you liked it!

[@rajiviyer9682]

This is simply amazing Nabil. Can't be put in words the value you provide through your tutorials! I have 2 questions regarding this tutorial: 1) How will the VBA code be impacted if the end user were to go and change the chart range from B2:H15 to say B2:J20? 2) Is there a way to control via VBA, the level of Zoom In?

[@uriellopez5438]

thanks , it is very useful to know other ways to do stuff

[@Officeinstructor]

Glad it was helpful!

[@user12345654]

Wonderful ! Thanks for sharing ! I could not understand the series overlap option. How does changing it from -27 to 100 affect the chart?

[@Officeinstructor]

That's a good question: We have 3 series (2 Scatter plot & one Column) adjusting the overlap to 100% makes sure that the triangles we created for the 2 scatter plot series are well centered on top of each column

[@mgangat]

Amazing Thanks for the tips

[@sasavienne]

Thanks Nabil for this excellent work. 👍 🌟 🌟 🌟.. Best regards. Salim

[@Officeinstructor]

My pleasure

[@amadeuswhitewalker2707]

Thank you sir!!

[@nadermounir8228]

Thank you Mr Nabil. Enjoyed the video great new stuff :) 😃

[@Officeinstructor]

Glad to hear that

[@IrfanKhan-b7b8i]

Great work amazing -

[@1310kumarrakesh]

Hi Nabil thankx for this wonderful info. One issue i am facing, whenever data refreshed, and values changed from negative to positive and vice versa then data labels disappear of changed values.

[@salilpattanayak7726]

Excellent ❤

[@apn6824]

Excellent Nabil...Great presentation... And you didn't explain why you add 800 as well as #NA. Its confusing...Pls clear that. God bless you

[@Officeinstructor]

I did mention that the 800 creates a gap between the Scatter plot chart and the column chart. I also mentioned that #N/A is to hide the data points where the IF condition is not met

[@apn6824]

@@Officeinstructor Thanks for the reply. Just one more query..How much to add whether it should be 800 or more or any amount for eg.50, 100 etc can also be added.

[@TheGhurabah]

Beautiful

[@DFAnto]

This chart is not dynamic , right? When i Change some data, it won't change the triangle ... right ?

[@samyraad5258]

🎩 off ...Mr Nabil when you will be teaching online classes.

[@Officeinstructor]

Very soon

[@mgrover5125]

Hi, Does any one knows the logic behind adding 800 in the If formula?

[@azizou47000]

please, the sentence '' Show #N/A as an empty cell " "" 06:32"" did not appear to me, given that I am working with excel 2013.

[@mirrrvelll5164]

Hi Nabil, #N/A is the same as =na() ? this # confused me at first..

[@Officeinstructor]

No they are different

[@OMERAGUYIDO]

Hello Nabil Can you share the full file ,not just the excresise?

[@Officeinstructor]

I don't usually do that...if you email me I can send you the finished file

[@OMERAGUYIDO]

@@Officeinstructor [e-mail]

[@OMERAGUYIDO]

@@Officeinstructor Dear Sir, I would like to convey my deepest gratitude for taking the time to assist me. Your KZbin videos have been extremely helpful and informative. As we corresponded earlier, I would highly appreciate your help with sending the full excel file and looking forward to it. Thank you again for your time and effort my email address is: [e-mail] Sincerely, Omer A.

[@yahiamohamed8826]

Please if you can send me working file thanks

[@JUSTINOPERAZA]

CUANDO USA LA FUNCION SI PORQUE LE SUMA 800

[@hct10]

Why there is +800 in 1st and 2nd function?

[@Officeinstructor]

To create the space between the column chart and the Scatter plot