Excel- Radar chart

By Ajeet Kumar

RADAR CHART

In radar chart, the categorical variable is displayed as spikes radiating from a central point. The values of a numeric variable is measured along the spikes and by joining these points, we get the radar chart for that. In above table, Month is a categorical or classifying variable and GROUP-A is a numeric variable. The radar chart is plotted for this Group. This is repeated for another numeric variable GROUP-B also.In Business Analysis, Radar Chart is useful to compare two brands etc.

Excel- Symbols

GENERATING SYMBOLS IN EXCEL

To generate symbols in MS-Excel, Press/Hold down the ALT key and then enter the numeric values using Numeric Keys. When the ALT key is released, the desired symbol is generated. For example, some selective symbols are tabulated below.

Press down ALT Key & Use Numeric Key	SYMBOL
1	☺
2	☻
3	♥
4	♦
5	♣
6	♠
7	•
8	◘
9	○
10	◙
11	♂
12	♀
13	♪
14	♫
15	☼
16	►
17	◄
18	↕
19	‼
20	¶
21	§
22	▬
23	↨
24	↑
25	↓
26	→
27	←
And so on

Excel- Create Dynamic range

By Ajeet Kumar 

EXCEL: CREATING DYNAMIC LIST

GIVEN: Suppose you have a list in column A of Sheet1 of a workbook. The list can grow or shrink as per need.

OBJECTIVE: You want to load all these data in a list. To achieve this objective, we can do the following steps:

STEPS:

1. Choose a cell on any sheet of the workbook.
2. Click Data > Data Validation > Data Validation…
3. The Data Validation dialog box appears.
4. In Validation Criteria, select List
5. Write the following formula in the Source text box and click OK.

When you add or remove data from the list, the list will get updated.

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)