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
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
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?
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
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.
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
@@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.
@@Officeinstructor Dear Sir, I would like to convey my deepest gratitude for taking the time to assist me. Your RUclips 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: omera42@gmail.com Sincerely, Omer A.
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
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
This chart is fantastic. Many of the comments below already stated how I feel about this tutorial. Thank you.
Great technique getting the coloured triangles and values above the chart. Looks good 👍 John
Fascinating , this will help us all to add emotions to numbers , Thanks our Picasso !!!
Thank you so much
Thanks nabil the best to come...
You are welcome
Very beautiful video and your teaching style, I'm your old fan thank u so much for teach us.
Thanks and welcome
Good and it is nice to hear from you.
Thank you for being a loyal follower
Just amazing and easy to follow, Thank you Sir
You are most welcome
Good tutorial..would love to see more from you 😊😊
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?
Extrasensorial. Wonderful tutorial. Thank you Nabil!!!
Great idea to visualize the data for comparison
Glad you liked it
Great tutorial!!!
Thank you!! It's eye catching chart. Very useful.
You're very welcome!
Mr. Nabil, you are the greatest what an amazing video thank you so much.
Many many thanks
Excellent work and very clear explanation. Keep it up
Glad you liked it Fahad
Wonderful chart 📊. Well explained.
Glad you liked it!
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?
thanks , it is very useful to know other ways to do stuff
Glad it was helpful!
Wonderful ! Thanks for sharing !
I could not understand the series overlap option. How does changing it from -27 to 100 affect the chart?
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
Amazing
Thanks for the tips
Thanks Nabil for this excellent work. 👍 🌟 🌟 🌟.. Best regards. Salim
My pleasure
Thank you sir!!
Thank you Mr Nabil. Enjoyed the video great new stuff :) 😃
Glad to hear that
Great work amazing -
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.
Excellent ❤
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
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
@@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.
Beautiful
This chart is not dynamic , right? When i Change some data, it won't change the triangle ... right ?
🎩 off ...Mr Nabil when you will be teaching online classes.
Very soon
Hi, Does any one knows the logic behind adding 800 in the If formula?
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.
Hi Nabil,
#N/A is the same as =na() ? this # confused me at first..
No they are different
Hello Nabil
Can you share the full file ,not just the excresise?
I don't usually do that...if you email me I can send you the finished file
@@Officeinstructor omera42@gmail.com
@@Officeinstructor Dear Sir, I would like to convey my deepest gratitude for taking the time to assist me. Your RUclips 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: omera42@gmail.com
Sincerely,
Omer A.
Please if you can send me working file thanks
CUANDO USA LA FUNCION SI PORQUE LE SUMA 800
Why there is +800 in 1st and 2nd function?
To create the space between the column chart and the Scatter plot