When I first started college as a young aspiring engineer ages ago, there was one particular thermodynamics professor who had an outsized impact on how I think about engineering design. In addition to being the kind of intimidatingly brilliant engineer they assign to weed-out classes who wrote the book he was teaching from, he also forced everyone to read his hand-bound manual on Microsoft Excel for engineers. While I can’t say I remember a whole lot about the Carnot cycle these days, that early Excel training stuck with me.
From building fancy iterative calculations to constructing well-labeled charts, he taught me not only how to work Excel but how to stretch it to do things most people don’t even know it’s capable of. As a young mechanical engineer, it basically became my programming language of choice. And anyone who has ever tinkered with the tools here at Portfolio Charts has experienced the fruits of that early education. Even if it wasn’t obvious, they were all built in Excel.
Of course, using a tool primarily designed for desktop spreadsheets as the foundation for web development has major limits. The interface can feel a little slow and clunky, there are technical limits to how many calculations a single spreadsheet can handle, and regardless of how much you try to finesse the UI it’s impossible to shake that classic spreadsheet feeling. There’s arguably a charm to it, but at some point it also becomes a barrier to new features. So for years I have had a list of things I’d love to do if only I could find the right tools to make them happen.
Well, apparently those tools have arrived. With the invention of highly-capable AI coding assistants, the barrier for a guy like me with lots of technical knowledge and a mind for design but minimum coding skills is all but gone. Getting the first working prototype back from Claude felt a lot like watching my first complex Excel model converge on a solution. It’s a game changer.
So today I am happy to announce the biggest single update to Portfolio Charts since I started it more than a decade ago. Every chart has been rebuilt from scratch. And they are way faster, much more powerful, and just plain fun to use.
Here’s a quick overview of some of the cool new features to look out for.
