Comparison Chart For Dashboards... Simple and Beautiful

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:

If you want to learn more Excel Tricks and become a Power User of Excel, subscribe to my blogs site

Follow me on Facebook:

Follow me on Twitter:
Subscribe to my YouTube Channel:

Find me on LinkedIn:
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”

[elenahicks]

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

[titan]

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

[UpExcel]

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

[RafiqulIslam-dvcu]

Great idea to visualize the data for comparison

[thakuranujsingh]

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

[ashwindesai]

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

[coachz]

Just amazing and easy to follow, Thank you Sir

[IvanCortinas_ES]

Extrasensorial. Wonderful tutorial. Thank you Nabil!!!

[FAlsufyani]

Excellent work and very clear explanation. Keep it up

[aig]

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

[adriaq]

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

[sasavienne]

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

[uriellopez]

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

[nadermounir]

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

[deepakjhurani]

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?

[rajiviyer]

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?

[samyraad]

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

[user]

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

[apn]

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