Comparison Chart For Dashboards... Simple and Beautiful
HTML-код
- Опубликовано: 8 июл 2020
- In this tutorial I show you how to compare sets of Values: Actual to Target, Year to Year sales
and visualize this type of values to show the increase or decrease between two sets in a simple yet beautiful comparison chart, that could be also part of a comparison dashboard
You can Download the Exercise File and follow along by clicking on the link here below:
www.Officeinstructor.com/comp...
If you want to learn more Excel Tricks and become a Power User of Excel, subscribe to my blogs site
www.OfficeInstructor.com
To Book a Corporate Training (at Client site or Remotely Anywhere in the world) visit: www.OfficeInstructor.com
Follow me on Facebook:
www.Facebook.vom/OfficeInstructor
Follow me on Twitter:
NabilXL
Subscribe to my RUclips Channel:
/ officeinstructor
Find me on LinkedIn:
www.LinkedIn.com/company/OfficeInstructor
Finally, if you find value in this tutorial, give it a Thumbs Up, share the video and subscribe to be notified when new posts are released because “The BEST is Yet To Come”
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
Great technique getting the coloured triangles and values above the chart. Looks good 👍 John
This chart is fantastic. Many of the comments below already stated how I feel about this tutorial. Thank you.
Thank you sir!!
Extrasensorial. Wonderful tutorial. Thank you Nabil!!!
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
Good tutorial..would love to see more from you 😊😊
Great tutorial!!!
Mr. Nabil, you are the greatest what an amazing video thank you so much.
Many many thanks
Thank you!! It's eye catching chart. Very useful.
You're very welcome!
Good and it is nice to hear from you.
Thank you for being a loyal follower
Excellent ❤
Great work amazing -
Thank you Mr Nabil. Enjoyed the video great new stuff :) 😃
Glad to hear that
Just amazing and easy to follow, Thank you Sir
You are most welcome
Amazing
Thanks for the tips
Wonderful chart 📊. Well explained.
Glad you liked it!
Beautiful
Excellent work and very clear explanation. Keep it up
Glad you liked it Fahad
Great idea to visualize the data for comparison
Glad you liked it
Very beautiful video and your teaching style, I'm your old fan thank u so much for teach us.
Thanks and welcome
Thanks Nabil for this excellent work. 👍 🌟 🌟 🌟.. Best regards. Salim
My pleasure
thanks , it is very useful to know other ways to do stuff
Glad it was helpful!
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?
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?
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.
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
🎩 off ...Mr Nabil when you will be teaching online classes.
Very soon
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.
Hi, Does any one knows the logic behind adding 800 in the If formula?
This chart is not dynamic , right? When i Change some data, it won't change the triangle ... right ?
Hi Nabil,
#N/A is the same as =na() ? this # confused me at first..
No they are different
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.
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
Why there is +800 in 1st and 2nd function?
To create the space between the column chart and the Scatter plot