AMAZING Excel People Charts using a FONT! Alternative for Bar, Column, Waffle and more!

[@bjbrooks]

Another superb video. I've watched several of Mynda's videos; I always come away with the impression that she can read my mind! Her demos are so clear, at just the right pace; while watching, I think "What if..." - and she answers the question in her next breath! Well thought out, rehearsed, edited and presented. First class.

[@MyOnlineTrainingHub]

Wow, thanks so much for your kind words, Brian! 🙏

[@adeohere]

Thank you so much. Great. This lesson helps me to solve a problem on conditional formatting.

[@MyOnlineTrainingHub]

Great to hear, Adeo!

[@IvanCortinas_ES]

This is amazing Mynda. As we would say in Spain: "Es una auténtica pasada". Thank you for being such an innovative person. And thanks to Alberto Cairo.

[@MyOnlineTrainingHub]

Glad you liked it, Ivan!

[@jonathanjackson4983]

Your MS Excel talent is obscene! You never fail to amaze me - thank you 😮

[@MyOnlineTrainingHub]

Aw, thanks so much, Jonathan!

[@bccabernet]

Absolutely true!! I am always in awe of Mynda's talent.

[@chrism9037]

Great as always, thanks Mynda!

[@MyOnlineTrainingHub]

Thanks for watching, Chris!

[@bccabernet]

Absolutely fantastic video -as per usual. Your instructions are always clear and easy to understand and follow.

[@MyOnlineTrainingHub]

Thanks so much!

[@SpotlightImpact]

Amazing as always! 🎉

[@MyOnlineTrainingHub]

Thank you!

[@darrylmorgan]

Hi Mynda!Great Tutorial Really Cool Chart Design Using WeePeople...Thank You :)

[@MyOnlineTrainingHub]

Glad you liked it, Darryl!

[@MlguelM]

Excelente info Mynda! Muchas gracias!

[@MyOnlineTrainingHub]

My pleasure, Miguel!

[@andrewbarkham8357]

Awesome visualisations, but why are none of the wee people wearing kilts??? :)

[@MyOnlineTrainingHub]

😁 good question, Andrew!

[@nickdowling429]

Incredible video - how can I do this without the RANDARRAY function please?

[@MyOnlineTrainingHub]

Glad you liked it. If you don't have RANDARRAY, you can use this formula: =CHAR(RANDBETWEEN(97,116)) then copy it to create a 10 x 10 grid.

[@nvicki2710]

Amazing! Really interesting and useful. Thank you so much!

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@chaosavylein]

great tip! But a question to your Excel template: when I want to create an analysis using the bar charts and conditional formatting with this font and then share it with my stakeholders, I need to keep the first sheet in there and make sure the recipients download the font first also, correct?

[@MyOnlineTrainingHub]

Glad you liked it! Yes, if you want to share the Excel file, you will have to also get the user to install the font on their PC. Alternatively, you can take a screenshot of the chart and embed it in PowerPoint and other reports.

[@alexanderadamov7883]

Another excellent video. I have Office 365 but not wrapcols(). Any idea why?

[@ricos1497]

It's on the insider beta version only just now I think. It might have been released for general consumption, but you'd have to be on the very latest release (if it has). Otherwise you'll have to wait! If you're just using office 365 for personal use then updating to Insider is quite useful, and you'll get all these types of functions in beta.

[@MyOnlineTrainingHub]

Glad you liked it, Alexander! You may just need to update Excel, or you may be on the semi-annual update channel, in which case you won't get it for a while yet. If you're on the current channel, then an update should do the trick.

[@jenniferowens3443]

I went to the link for the font but am seeing a lot of files that can be downloaded. Which file is the actual font that I would want to add to my Windows Font folder? Thank you!

[@MyOnlineTrainingHub]

Hi Jennifer, the font files end in .ttf (true type font).

[@deepaliambekar362]

This is brilliant!!!

[@MyOnlineTrainingHub]

Glad you like it, Deepali!

[@michaelomosebi6374]

Heavy stuff! Well done

[@MyOnlineTrainingHub]

Thanks, Michael!

[@arunachaleswaran]

Wow .. Superb ..

[@MyOnlineTrainingHub]

Thank you! Cheers!

[@kirkbrown4585]

Can't figure out how to install it. I guess it's assumed that everyone knows how to install fonts?

[@MyOnlineTrainingHub]

Hi Kirk, you can simply download the font file, which is the .ttf file (true type font) and put it in your fonts folder: C:\Windows\Fonts

[@technomantizzz]

Thanks

[@MyOnlineTrainingHub]

Welcome 😊

[@snipelite94]

weepeople isn't a standard font, though? I've got 365 copy and don't have it

[@MyOnlineTrainingHub]

You can download it from the link in the video description.

[@Gethin1978]

@@MyOnlineTrainingHub How do you install it from there??

[@alexanderadamov7883]

@@Gethin1978 Click on the .ttf file, then open and then click install in the upper left corner.

[@JCEurovisionFan1996]

What if there's no WRAPCOLS function?

[@MyOnlineTrainingHub]

You can manually create the table. Just repeat the first 20 letters of the alphabet 5 times to get a grid of 100.

[@markclifton9524]

How on earth do you know all these things? 🤔

[@MyOnlineTrainingHub]

Lots of reading 😁

[@King-lb1om]

Who Should Believe Microsoft Give Next Free Update of 365 Version in Windows 11

[@golubtsoven]

.