Text Histogram :
Text Histogram can be created with the help of IF and REPT function .
Example shown in below print shot :
In Example , we calculated Balance of Trade (column D) by subtracted column C from column B, which comes some positive value as well as some negative values. Column F, G and H are outlined as text histogram. So, Column F is for negative values. Column G for Years and Column H for positive values.
Column F formula : =IF(D2<0,REPT("n",-D2),"")
Column G formula : =A2
Column H formula : =IF(D2>0,REPT("n",D2),"")
In Column F and H, we are repeating text "n" equal to the values in Column D. Difference in both column formula is just comes with negative sign as column F is for negative value and for text "n" repeating times we need to convert it as positive.
Thank you !!
Text Histogram can be created with the help of IF and REPT function .
Example shown in below print shot :
In Example , we calculated Balance of Trade (column D) by subtracted column C from column B, which comes some positive value as well as some negative values. Column F, G and H are outlined as text histogram. So, Column F is for negative values. Column G for Years and Column H for positive values.
Column F formula : =IF(D2<0,REPT("n",-D2),"")
Column G formula : =A2
Column H formula : =IF(D2>0,REPT("n",D2),"")
In Column F and H, we are repeating text "n" equal to the values in Column D. Difference in both column formula is just comes with negative sign as column F is for negative value and for text "n" repeating times we need to convert it as positive.
Thank you !!
No comments:
Post a Comment