|
Daily Dose of Excel
|
Daily posts of Excel tips…and other stuff
|
-
TM Custom Radar Chart add-in
A Radar Chart, also known as a Spider Chart, visually compares several entities (products, organizations, investment opportunities, or even people) on multiple dimensions. For example, a manager of a diagnostic imaging (radiology) center might want to compare her facility with the competition on dimensions related to patients such as Time To Appointment, Report Turnaround Time, [...]
-
Making a Wiki Table
Writing for Wikipedia is a bit like writing in your third language—you know there are words for it, but your guides are from your second language—Wiki pour Les Nuls or maybe Wiki para Maniquíes. It’s a different dialect of HTML. Having done it for several years, Wikipedia’s goal seems to be a reduction in keystrokes [...]
-
How to Estimate Freelance VBA Projects
You already know how much to charge. That’s only half the story. You still need to figure out how many hours it will take. First, write down all the tasks that are required. Be as specific or general as you like, but specific will get you a better estimate. For example, I might split a [...]
-
Comments Temporarily Closed
I lost my Akismet plugin that keeps the comment spam at bay. In the last 10 minutes, I’ve got 52 spam comments. Until I get this fixed, I’ve turned off commenting. Sorry for the inconvenience.
-
Extending Built-in Classes
I’m catching up on Doug Glancy’s blog, yoursumbuddy, and in particular Building a Workbook Table Class. I wondered if it would work better inside the workbook class rather than in its own. Most classes in Excel don’t come with a user interface, but the Workbook class does – the ThisWorkbook module. In that module, you [...]
-
Income Statement Waterfall Chart
I want to make a chart that looks like this: This example comes from Powerpoint. There’s another chart right next to it showing percent of revenue. I had to edit the chart in Powerpoint to obfuscate the data. That was a lesson in itself. I right clicked on the chart and chose Edit from the [...]
-
Turning an Excel table into CSS
This is my very ugly, very formatted, table to test my translation skills, first into HTML and now into CSS. Every cell has at least two formats that have a counterpart in CSS, and the table runs through all options at some point. Row(5) has nine different fonts, at assorted alignments, from left to [...]
-
My Excel 2010 Journey
I almost finally installed 2010. I say ‘almost’, because I’ve only installed it on a machine that previously had 2003 on it. I have yet to install it on my 2003/2007 machine. I guess I’ll be uninstalling 2007 and then installing 2010. Seems like a hassle, but if I tell it to upgrade, it will [...]
-
Infinite Loop of Errors
This morning one of my add-ins kept giving me Run-time error ’438′; Object doesn’t support his property or method. I would click OK, and the error would immediately pop up again. The cause of the error was pretty simple – in fact I’m surprised it compiled before I shut down last night – but a [...]
-
Creating an Excel Mashup
Following up on my previous posts sharing my initial Excel mashups (http://www.dailydoseofexcel.com/archives/2012/01/29/excel-mashup-2/ and http://www.dailydoseofexcel.com/archives/2012/01/25/excel-mashup-1/), this post shares the details of how I created the second mashup. It assumes a basic familiarity with C-style syntax, asynchronous processing, and callback functions. For a version in a page by itself (i.e., not in a scrollable iframe as below) [...]
|
