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 1st and the 2nd charts as Bar charts and the 3rd chart would be the Dot chart.

First we prepare the 1st  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 2nd 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”.

3rd 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 10th, 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.