Adding Forms Scrollbars to your Excel Charts and Spreadsheets

One exercise that is done with almost religious fervor in all companies at the beginning of each financial year is the preparation of the budgets and targets for the next year. Every year a fresh faced newly recruited manager is identified, handled this dreaded responsibility and asked to present the first draft to the management team. And so the rookie spends a couple of nights pouring over multiple spreadsheets and a plethora of for complicated ...

Continue Reading

Adding Forms Scrollbars to your Excel Charts and Spreadsheets

How to create waterfall chart in excel in 2 minutes

Posted on 08 October 2008

How to create waterfall chart in excel in 2 minutes
A waterfall chart is used to represent a set of figures when they all impact the same derived number. A waterfall chart helps to link the individual values to a whole. A profit and loss statement is a good example where the magnitude of each figure has an impact on a derived number (which happens to be Profit in this case). A colleague of mine recently had a budgeting exercise assigned to him where he had to project the P&L figures ...
Continue Reading

Comments (44)

How to make Visio like flowcharts in excel

Posted on 06 September 2008

How to make Visio like flowcharts in excel
I sometimes use connectors and autoshapes in excel to make flowcharts for my projects. A little refined touch and you can have them looking nealy like the ones made in Visio. I say *nearly* because although everything moves, reshapes and resizes properly, the connectors still bend at 90 degrees unlike the ones in Visio which curve smoothly.....but nonetheless a small price to pay especially if you don't have ready access ...
Continue Reading

Comments     

Creating tree structure in excel

Posted on 06 September 2008

Creating tree structure in excel
You can use the group and outline features in excel to create tree structures. On expanding each node the next branch becomes visible. You can download the file here.
Continue Reading

Comments (1)

Excel Chart Types – Advanced

Posted on 01 September 2008

Excel Chart Types - Advanced
Here are a few more chart types. These can be used to represent multi-dimentional data. Download the file with advanced excel chart types here.
Continue Reading

Comments     

Excel Chart Types – Basic

Posted on 31 August 2008

Excel Chart Types - Basic
These are some basic chart types in Excel. You can play around with these by downloading the file here. Stephen Few, Data visualization Guru and author, mentions a few rules for creating charts on his website PerceptualEdge. Some good reads are: Practical rules for using colors in charts Godin’s Silly Rules for Great Graphs Stephan has, over the years, written on many facets of presenting data ...
Continue Reading

Comments     

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES