How To Create An In-Cell Gantt Chart With REPT Function

Creating In-Cell Charts with REPT Function is a smart move. You can use these charts in your dashboards to give a quick view to your user. I have used this text repeating formula to create an In-Cell Column Chart & a Star Rating Template. But, here I have created an In-Cell Gantt Chart for the sake of my laziness. Let me […]

➲ Continue Reading

How To Create A In Cell Column Chart With REPT Function

Creating an In Cell Column Chart by using the REPT Function is the second part of our in cell charting Series. Yesterday, I had used this text repetition formula to create a star rating template in excel. Basic Idea of creating a column chart with REPT Function is as simple as we create a normal column chart in excel. I have used a percentage data set to create […]

➲ Continue Reading

How to Create a Star Rating Template in Excel

Here is a quick tip for you to create a star rating template in Excel.To create this star rating template all you need is REPT function. REPT Function is useful when you want to repeat a given text for a number of times.Steps to Create a Star Rating TemplateInsert two different types of stars (☆★) […]

➲ Continue Reading

Change the Default Chart Type in Excel

Do you know you can insert a chart with a shortcuts key? You can use Alt + F1 to insert a chart. But here’s a twist. In Excel, default chart type is a two-dimensional column chart. So, if you want to insert a line chart or any other chart which you use frequently with a […]

➲ Continue Reading

Select Non-Contiguous Cells in Excel

Normally, when you need to select multiple cells which are not continuing, you press and hold the control key and then select each cell with the mouse.Right?That’s the simple method.But I can bet that you have never heard about selecting non-continues cells without using a mouse.The reason for this is no one ever found this […]

➲ Continue Reading