When you create a chart, you select a range. Now assume, one more row of data is added. But that will not be reflected in your chart as your chart had a fixed range. — The Excel for this article can be downloaded from Dynamic Charting — A work around is to select more rows…
Category: Articles
Article 3 – Show Date for a Coming Day (e.g. Coming Saturday)
There are many circumstances in life where we want to determine the coming day. We are always eager to wait for Saturday. Hence, we want to show the coming Saturday date. We want to go to a blockbuster movie on Wednesday, hence we want coming Wednesday date. All these are fairly easy by Windows Date…
Article 2 – Single Underline / Double Underline in Accounting
Accountants were the first and foremost users of spreadsheet programs and they are still the dominant group using Excel. If you are working for accountants, you need to know this concept as these are critical formats for the accountants. They, sometimes, use Single Underlining and Double Underlining in their statement of accounts. Single Underlining is used to…
Article 1 – Convert Number Format into Text Format
The very first post which I want to write about is conversion of numbers into text. For example, if have a numeric value of 2.23, it should be converted to text value of 2.23. We may need this in many data manipulation scenarios. I will not go into why we need this but directly jump…