Search results

I hear you, Narayan. Believe it or not, your non-critique is actually a critique (and a valuable one at that)! And yes, I get your point. Actually, when you think about it decisions and trends are two sides of a coin. It's like cause and effect. In no particular order, a decision creates...

Hi Narayan, Thanks for the comments. They are definitely things for me to remember when designing dashboards. By the way, I do want people to critique my chart, whatever their comments may be. But please remember that this is 1 chart built for a certain scenario, not an entire set of...

Hi Everyone, I'm Dave from Seattle, Washington. I've been using Excel and vba for a little while now, coming into the fold around 1999 after finding out I could use my Visual Basic skills within Excel. Echoing others, I have to say Chandoo, you've build an awesome resource. Been visiting...

No need to wait, I stand corrected. Vlookup does work well, and with the added benefit of dynamic row references, meaning adding metrics to a dashboard is as simple as copying the formula down to the new row. I tried with the following formula in E15 of a dashboard tab...

I think the problem with vlookup is that it breaks when you add a column. The problem with indirect is that it breaks when you add a row. I didn't understand at first either, but if you think about the fact that the data expands to the right as new periods are added (at col J), it makes...

SirJB7, I really appreciate your comments. Also, you don't need to hold back. I can take it. When I start building charts and dashboards for the sake of my ego, I'm in trouble. Your points are valid and I will take them into consideration. The chart was originally part of a "monthly"...

Thought I'd throw out an idea for others to elaborate on. Haven't looked into the reversecell udf, so forgive me if this is the same logic. How about a udf using the split function? It creates an array that you could loop through in reverse. The tricky part would be the delimiter. From...

Adding on to Luke's suggestion. You might be able to use a Windows command. Try looking into wmic (Windows Management Instrumentation Command-line) for starters: example: wmic desktop get screensaveractive I just started researching this, but I ran out of time (leaving for home). Not...

You might be able to use offset instead of indirect. Using your spreadsheet, I tried the following formula in cell E15 of the Financial tab: =OFFSET(Data!$D9,0,2,1,1) Basically, anchor on column D and offset 2 columns.

I would like your opinion on the usefulness of this chart and how I can improve it. http://i39.tinypic.com/2uo6zi1.png The chart displays historical data. Let’s say it’s for monthly percentage increase in sales. It shows the following: 1) Percentage increase/decrease sales for each...