Multi Level Data Labels in Charts
When you have a big data set for a chart you naturally get too many data lables. But if your data can be grouped in...
Tagged: excel tutuorial
Offset Function
When you want to select a cell (or range of cells), that is 2 rows down and 3 columns to the right from Cell B12,...
Interactive Chart Example – 3
Here is another interactive chart example. This time I’ve made a chart that shows data as you click. Great for presentations.
Sumproduct Function
Sum product function lets you calculate sum of values with corresponding arrays. For example, if you have sales quantites and unit prices for a series...
Calling Macros to Action
You can call your macros by a couple of easy ways. In this post I’m going to explain how to call your macros to action.
Excel Macro Recorder
You don’t need to know how to code VBA in order to make macros that does basic tasks. There is a handy tool named Excel...
