Without a doubt, one of the greatest researchers, always going into depth into problems and solving scenarios that optimize the work. Great job, Mark. Thank you very much for sharing. All the work is very professional.
Thank you, Mark. I've been considering an alternative method without using VBA by placing each element in separate cells, formatting them accordingly, and then creating a linked picture from those cells for the chart title.
Additionally, I noticed that linked images made my dashboard very slow. I used VBA to format the text boxes dinamic, but Mark took it to another level. Congratulations. #Brazil
Amazing tutorial and cool result! Thanks! I had to handle some formulas a bit differently to work with my Excel 2019 where FILTER and XLOOKUP do not exist, but got to the same result thanks to your tut and UDF function.
Great stuff. Yes, the techniques can be used with other formulas. FILTER and XLOOKUP are just too convenient not to use. Hopefully you’ll get them soon.
You asked in your email if I have ever seen that technique before and the answer is yes, I have been using it for chart titles and in the same way you did in a cell for several years now.
Yes but … I don’t know VBA, Mark, so I use formatting the cell/s and then use the camera tool! A bit cheat but, hey, you want us to save time!! And it works ;)
dynamic titles, check, but have them formatted, that's new. But as I'm probably not allowed to make xlsm-files anymore as they don't play well with Sharepoint, I can't use VBA anymore . 🤔
Unfortunately, they don't play well with SharePoint. With an Office Scripts / Power Automate solution it certainly won't be instant, there would be quite a lag.
Nice video, though many companies do not allow their employees using macros or vba due to high security standards. I always struggle to share such files and therefore my first attempt would be a hack here with overlaying text boxes which are already in a certain color. (I haven’t tried this idea so far)
I feel sorry for all those employees who will be stuck working longer hours doing pointless tasks because their company turned off VBA. Such a shame. The issue with overlying text boxes is the spacing between words is unlikely to work.
Hello! i am wondering something. For the second formula that gets the prior to value. What value would be returned if Q1 is selected as value in the quarter drop down list ? Q0? Shouldn’t we insert if formula with conditions to calcul quarter number ?
If you select Q1 it shows an error in those cells. But if we select Q1, the IF statements ensures those cells are never part of the final formula. So, it doesn't cause any issues.
Spaces are tricky as it's also the range intersection operator. If used in the wrong place in the formula they can cause havoc. I'm still holding out for a better formula bar that allows proper indentation.
@@ExcelOffTheGrid In over 20 years as an Excel specialist, spaces have never played havoc in my formulas and they make them infinitely easier to read, for me.
Without a doubt, one of the greatest researchers, always going into depth into problems and solving scenarios that optimize the work. Great job, Mark. Thank you very much for sharing. All the work is very professional.
I used to use this technique all the time when I worked in industry. It really helped my work to stand out.
Never saw that technique before. I was unaware of the function. Thanks!
The Impossible ACHIEVED!
Thanks for watching.
Innovative user-defined function for creating impactful and dynamic chart titles. This UDF revolutionises data visualisation.
Thanks - I appreciate you saying that 😁
Thank you, Mark. I've been considering an alternative method without using VBA by placing each element in separate cells, formatting them accordingly, and then creating a linked picture from those cells for the chart title.
I think column widths become the issue. As it’s difficult to get the spacing to look reasonable.
Additionally, I noticed that linked images made my dashboard very slow. I used VBA to format the text boxes dinamic, but Mark took it to another level. Congratulations. #Brazil
I like how you're always looking at your excel. 😊
Amazing tutorial and cool result! Thanks!
I had to handle some formulas a bit differently to work with my Excel 2019 where FILTER and XLOOKUP do not exist, but got to the same result thanks to your tut and UDF function.
Great stuff. Yes, the techniques can be used with other formulas.
FILTER and XLOOKUP are just too convenient not to use. Hopefully you’ll get them soon.
@@ExcelOffTheGrid Thanks, I am planning to get Excel 2021 😅
Brilliant!! Thanks.
You're welcome!
Thank you
You're welcome
new to me.🙂
No I haven't seen it ever before. Thanks for the share.
Thanks for watching 😁
Great as always Mark. Thanks
Thank you Ismael 😁
You asked in your email if I have ever seen that technique before and the answer is yes, I have been using it for chart titles and in the same way you did in a cell for several years now.
Great stuff, with the formatting applied too?
Yes but … I don’t know VBA, Mark, so I use formatting the cell/s and then use the camera tool! A bit cheat but, hey, you want us to save time!! And it works ;)
Wonderful video….now can you write a macro to make the users appreciate the work that went into this olution😊
Thanks 😁
We could change the output of the UDF so that it says - "This is hard, so appreciate the effort I put in?" 😂
dynamic titles, check, but have them formatted, that's new. But as I'm probably not allowed to make xlsm-files anymore as they don't play well with Sharepoint, I can't use VBA anymore . 🤔
Unfortunately, they don't play well with SharePoint. With an Office Scripts / Power Automate solution it certainly won't be instant, there would be quite a lag.
Awesome Mark, great video!
Thank you, I'm glad you enjoyed it.
Awesome! 👍👍
Thanks Kebin 😁
Nice video, though many companies do not allow their employees using macros or vba due to high security standards. I always struggle to share such files and therefore my first attempt would be a hack here with overlaying text boxes which are already in a certain color. (I haven’t tried this idea so far)
I feel sorry for all those employees who will be stuck working longer hours doing pointless tasks because their company turned off VBA. Such a shame.
The issue with overlying text boxes is the spacing between words is unlikely to work.
Hello! i am wondering something. For the second formula that gets the prior to value. What value would be returned if Q1 is selected as value in the quarter drop down list ? Q0? Shouldn’t we insert if formula with conditions to calcul quarter number ?
If you select Q1 it shows an error in those cells. But if we select Q1, the IF statements ensures those cells are never part of the final formula. So, it doesn't cause any issues.
Apotheosis👏👏👏👏👏
Thanks 😁
IfindExcelformulaseasiertoreadwhenspacesareused... 🤔
Spaces are tricky as it's also the range intersection operator. If used in the wrong place in the formula they can cause havoc. I'm still holding out for a better formula bar that allows proper indentation.
@@ExcelOffTheGrid In over 20 years as an Excel specialist, spaces have never played havoc in my formulas and they make them infinitely easier to read, for me.