Category Archives for Charts

The 5 Step Process to Make a Pictograph in Excel

If you know how to present data in an understandable and effective way, you can deliver your message strongly.For this purpose, one of my favorite things is a PICTOGRAPH and in Excel, creating a pictograph is quite simple and easy.Today in this post, I’d like to share with you a simple step by step process […]

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 […]

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 […]

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 (☆★) […]

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 […]