Author Archive

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.

Learn how to make a Circular Arc Chart in Excel.

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.

Learn to how perform Maths on Tables of Numbers in Microsoft Word.

Learn a technique to control multiple cells with 1 Control.

Learn how to develop a Conditional Rank or Rankifs formula in Excel

Learn how to use Solver to allocate players evenly to Teams.
A Solver Tutorial.

Learn how to conditionally format Chart Data Labels without VBA

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 […]

Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.

Chandoo.org is looking for your ideas!
What would you like to see discussed in future posts at Chandoo.org ?

Lets take last weeks Stacked Bar/Column Chart and add some high-performance steroids.

Learn how to convert a Roman Numeral to a Number using this nifty formula. No VBA required.

Learn how to develop a Stacked Bar chart with Indicator Arrow in this Tutorial

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.