How to Create Dynamic Variance Charts with Arrows | Show Change to Previous Year / Budget

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/variance-chart-file

[@302music8]

Brilliant use of intentional "#N/A" results in the formulas to eliminate the unwanted "0" labels on the chart!

[@DmitryWhite82]

The latter versions are indeed more intuitive and easy to read. I do love what you're doing, Leila

[@LeilaGharani]

Thanks Dmitry. I agree - and they take up less ink too.

[@michaeldiamond2726]

Yes, we have Mike, Will and Leila. I've worked with Leila, taken a number of her courses and she is fabulous. When she solves a problem she is trying to find the most efficient way to achieve that task. I definitely tip my hat to all 3 of them. When I grow up, I want to be like them!

[@LeilaGharani]

Thanks Michael for the very kind words! I am very happy to have joined this amazing online Excel community. You should consider making your own channel or site. You always find gold nuggets and we can all learn from them.

[@michaeldiamond2726]

That is so sweet of you to think that I can contribute something to the community. Learning from you has totally opened my eyes as to amazing charts can be!

[@unmeshrajhans7547]

Thanks Lelia for the variety of the ways to show the comparison. I would prefer version C. Many thanks for simplified way to teaching.

[@maherahmad6982]

We have Mike, Leila and Bill Jelen - sure will have strong confidence in excel. I so pleased

[@LeilaGharani]

Thank you Maher! That means a lot! There is a great online Excel community out there and we get to all learn from each other and improve.

[@SuperWolfkin]

this is brilliant. I knew subscribing would pay off. this is perfect for what I've found myself doing. only instead of companies it's different categories of a budget.. I'll definitely be watching this a few more times.

[@SuperWolfkin]

yeah I prefer (A) and (B) versions

[@LeilaGharani]

Perfect! Glad this video comes at a good time.

[@excelisfun]

That is a really cool chart! Thanks!

[@LeilaGharani]

You're welcome Mike. Charts are really fun. There is so much flexibility behind the scenes...

[@SpotlightImpact]

Such a cool trick. Thanks for sharing this!

[@michaeldiamond2726]

Thank you Leila for the kind words, I wouldn't know where to start or what tools I need to make that happen.

[@LeilaGharani]

I could help with that Michael....Let me know when you're ready.

[@michaeldiamond2726]

That is so kind of you to do that Leila. I'll be in touch.

[@jaredfromtexas7484]

I think I like version C the best. In the past few weeks, I have learned a lot of new things about Excel from your videos. Thanks!

[@LeilaGharani]

Thanks for your feedback. I'm glad to hear you learnt new stuff from the tutorials :)

[@cshahed]

All of then are great, can be used it many ways. Thanks Leila!!

[@brianhogan9563]

Are you going to show any error box charts in any of you videos? If not do you recommend any of your colleagues?

[@tahirshah6979]

Use variation(s) or difference(s) word instead of variance. The variance and standard deviation are statistical measurements which shows average deviation from central point of data.

[@shukorgandak9965]

Thank you. Very useful. I Prefer version 'C'.

[@shaikhzahid2363]

Many thanks for sharing your chat trick. really awesome videos... I love it......,

[@LeilaGharani]

Glad you like them.

[@ThuyLe-ic8qw]

I prefer C :)

[@ericpaysant4532]

Bravo pour les vidéos les explications sont claires

[@LeilaGharani]

Merci :)

[@nikesh421]

I use the arrows to indicate changes in percentage in between columns

[@ikebana8185]

Great Chart ever. Thanks so much!!

[@LeilaGharani]

You're very welcome. I'm glad you like it!

[@dileepreddy1876]

Hi Leila, The 4 charts are super☺ the best one is "D"

[@LeilaGharani]

:) Thanks Dileep

[@kalaiarasan698]

Thank you 💚

[@JoseMaria-jt7dd]

Genia!!!

[@LeyzerC]

Is there a way do make it dynamic with slicers? For example: having a slicer that filters months so I filter months to February it will show the variance from January to February and if then change the filter to March it will show the variance from February to March?

[@douglaszulu6281]

I prefer version D as well it is neat and easy to follow

[@LeilaGharani]

Agree :)

[@esthercraft]

Super cool chart!!!. Really enjoy all your tutorials. Does these variance and custom format charts takes up lots of space in excel, for eg: if i include 20 of these charts in one worksheet, together with 20 other pivot tables and charts, will these charts takes up alot of excel space (due to the formulas and customs formats?)

[@hardikpanchal8106]

Hi Leila, Thank a lot for your excel videos for charts help me a lot to enhance my skills in Excel, and also I have created some macros. Now I want that whenever someone add-inn my Excel it automatically add a custom ribben for my Macros, Can you please help me in this.

[@顏天保-w8s]

This really Helpful! Thank you!

[@_maik_]

Hey Leila! Where can I find the complete course of this video? Or is it just a two video online course on KZbin?

[@MyRobin38]

I have to try this

[@automationguide3498]

Thank You. I will Prefer Option : C. However , I have applied Option A while separating Weekday and WeekEnd Bars giving different colors.

[@LeilaGharani]

You're welcome Harsha.

[@micw3992]

Hello Leila, just started following your channel. Very impressed with the content and is really useful. Please can you advise what font style and size you are using for your chart labels?

[@abnambro1000]

Thank you! your vid are very helpful

[@Amr-Ibrahim-AI]

Hello Leila. All your videos are awesome. Didn't you think in developing some customers visuals for Power BI? You would add a great new flavor to the visuals there. What do you think?

[@ismailismaili0071]

You are just doing a great job thank u for helping us get better on charts and by the way i like C chart even though they all looks good because anyone can reads them all

[@LeilaGharani]

Thank you Ismail. Agree - they are very easy to read.

[@ismailismaili0071]

I really want you to teach me many things may i have your email address please

[@ytforum]

Nice to see this

[@jacksonnova4736]

i love the c. this is very helpful

[@LeilaGharani]

Glad you find it useful Jackson :)

[@vida1719]

Just Amazing! I love version C

[@LeilaGharani]

Thanks Vida. Gald you like it.

[@nathansoori]

I like your version one Leila. I have tried with error bar line style with end type instead of begin type without changing the formula to negative and arrows are pointing to the right direction. Hope I have got it right?

[@LeilaGharani]

...that should work too. Maybe the data labels would look a bit misplaced though...

[@_maik_]

@Leila Are these things in any of your courses, or is it only on KZbin?

[@LeilaGharani]

I think I might have a variation to this one in my charts course.

[@hosseinhosseinpoor4845]

thanks

[@adamwarrick2970]

How do you show this using a pivot table?

[@robertakwasiadjei8223]

Hello Leila, thanks for the good work. By the way how can I enroll into your excel advanced program?.

[@LeilaGharani]

You're welcome Robert. You can see my current courses here: www.xelplus.com/courses/

[@tobilobaadaramati7758]

Leila, I love your videos. They are simple and easy to assimilate. Anyone interested should also subscribe for her courses on Udemy.

[@LeilaGharani]

Thank you Tobi for your comment and the support. Very glad to hear you find the videos useful.

[@kalaiarasan698]

C and d was best

[@brandoncradeur5746]

where's the link to download this chart?

[@LeilaGharani]

In the description - Just click on "Show More" below the video.

[@NarendraSunku]

I will Prefer Option : C.

[@LeilaGharani]

Option C seems to be a popular one :)

[@Lu_Ca]

Why arrows with same % but different sign are DIFFERENT. I mean the 8% red arrow is SMALLER than the 8% green arrow.

[@michaelkan01]

I prefer "C"

[@desipk3290]

D

[@aminrahman6906]

D

[@DavidPattiruhu]

D