Add a fancy line for Presentation in Excel

To add a fancy line in a Presentation we use the “Rept” formula along with a symbol so that it shows the symbol repetitively in a cell. We use this function to prepare the Incell Chart in Microsoft Excel.

In this article we will create 3 type of charts. We call the 1^st and the 2^nd charts as Bar charts and the 3^rd chart would be the Dot chart.

 
First we prepare the 1^st  Chart

Let’s take an example and understand how we can present the data with decorative lines.We have sales data from the range C4 to G13. In which column C contains Agent list and column D contains working months.

 
To prepare the fancy line presentation follow below given steps:-

• Enter the formula in cell E4.
• =REPT("I",$D4) press enter.

• Change the font style as Arial.
• Go to the Home tab select “ARIAL” font style from Font group.

• The symbol is repeated 10 times in cell E4, fill it down to E13.
• Select the cell E5, Copy by using the key “CTRL + C” and then select the range from E5 to E13 and paste the formula by pressing the key CTRL + V.

 
This is all about the Bar Chart by using the Arial font.

Note: In this formula “I” will repeat on the basis of numbers which are available in the related cell.
 
To prepare the 2^nd bar chart follow below given steps:-

• Enter the formula in cell F4.
• =REPT("n",D4) press enter.

• Change the font style as Wingdings.
• Go to the Home tab select “Wingdings” font style from Font group.

• The symbol is repeated 10 times in cell F4, fill it down to F13.
• Select the cell F5, Copy by using the key “CTRL + C” and then select the range from F5 to F13 and paste the formula by pressing the key CTRL + V.

 
Note: Wingdings font style is displays the above symbol in place of “n”.
 
3^rd type of Incell chart by using the font “Courier New Style”.

Follow below given steps to create the Dot chart.

• Enter the formula in cell G4.
• =REPT(" ",D4-1)&"o") press enter.

• This formula will take space and will place on 10^th, place will depend on the number of month’s cell.
• Change the font style as Courier New.
• Go to the Home tab select “Courier New” font style from Font group.

• Fill it down to G13, Select the cell G5, Copy by using the key “CTRL + C” and then select the range from G5 to G13 and paste the formula by pressing the key CTRL + V.

 
This is all about how we can add a fancy line in our presentation report using Microsoft Excel’s Formulae.

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com