All articles in 'Posts by Hui' Category
![The Excel Mandelbrot](https://chandoo.org/wp/wp-content/uploads/2023/01/MB1.png)
This post examines the implementation of the Mandelbrot Function within Excel without the use of VBA code. It explores how this is done using Real and Complex numbers.
Continue »![Circular Arc – Doughnut Charts](https://chandoo.org/wp/wp-content/uploads/2019/05/DH_17.png)
Learn how to make a Circular Arc Chart in Excel.
Continue »![Hui’s World ! – An Excel Project of Global Scale.](https://chandoo.org/wp/wp-content/uploads/2018/10/Huis-World.gif)
Hui’s World is an advanced Excel animated chart displaying the Earth, Continents, Countries and States and key geographical features.
This post will describe how it works and how it was made.
![Performing Maths in Microsoft Word (In an Excel Blog)](https://chandoo.org/wp/wp-content/uploads/2018/08/MIW31.png)
Learn to how perform Maths on Tables of Numbers in Microsoft Word.
Continue »![Formula Forensics 043: Rankifs or Conditional Rank](https://chandoo.org/wp/wp-content/uploads/2017/10/Rankif0000.png)
Learn how to develop a Conditional Rank or Rankifs formula in Excel
Continue »![How to Distribute Players Between Teams – Evenly](https://chandoo.org/wp/wp-content/uploads/2017/10/EvenTeams0000.png)
Learn how to use Solver to allocate players evenly to Teams.
A Solver Tutorial.
![Conditional Formatting – Chart Data Labels](https://chandoo.org/wp/wp-content/uploads/2017/10/condlbl000.png)
Learn how to conditionally format Chart Data Labels without VBA
Continue »![How to add a lot of Goal Seeking to a model](https://chandoo.org/wp/wp-content/uploads/2017/07/MR_Hdr.jpg)
Recently in the Chandoo.org Forums, MR06 asked the question, “I am trying to create a sensitivity table that tells me what amount of equity I need to include in a deal in order to get a fixed IRR as the year 3 sales price changes.” MR06 was using Goal Seek to change the equity input […]
Continue »![Formula Forensics 042: Reverse Text – A Formulaic Solution](https://chandoo.org/wp/wp-content/uploads/2017/01/TJ_Header2.png)
Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.
Continue »![We Want Your Ideas](https://chandoo.org/wp/wp-content/uploads/2011/06/Chandoo-wants-you-300px.png)
Chandoo.org is looking for your ideas!
What would you like to see discussed in future posts at Chandoo.org ?
![Stacked Bar/Column Chart with Indicator Arrows – Advanced](https://chandoo.org/wp/wp-content/uploads/2016/09/SBA08-1.png)
Lets take last weeks Stacked Bar/Column Chart and add some high-performance steroids.
Continue »![Formula Forensics No. 041 – Convert a Roman Numeral to a Number](https://chandoo.org/wp/wp-content/uploads/2016/09/RomanHDR.png)
Learn how to convert a Roman Numeral to a Number using this nifty formula. No VBA required.
Continue »![Stacked Bar and Indicator Arrow Chart – Tutorial](https://chandoo.org/wp/wp-content/uploads/2016/09/SBAHDR.png)
Learn how to develop a Stacked Bar chart with Indicator Arrow in this Tutorial
Continue »![Hourly Goals Chart with Conditional Formatting](https://chandoo.org/wp/wp-content/uploads/2016/09/HGC_Hdr.png)
A while back I developed a solution to a Chandoo.org Forum question, where the user wanted a 4 level doughnut chart where each doughnut was made up of 12 segments and each segment was to be colored based on a value within a range. If the values changed he wanted the chart to update, Conditional Formating like:
This post looks at how this was achieved.