How to Enable PowerPivot In Excel 2010 Using Simple Steps

“PowerPivot will bring a lot more freedom to our information workers because they will have powerful, easy-to-use data analysis tools right on their PCs…without having to come to the IT department for help…” Ayad Shammout, Lead Technical Database Administrator, CareGroup Healthcare System I am sure above words will definitely inspire you. If you really want freedom […]

How to Create a Population Pyramid Chart in Excel

To analyze population data we can create a Population Pyramid in Excel. Here I have listed 3 different ways to create an Excel Pyramid Chart. All the three methods are simple to use & you can choose anyone which you think is a perfect fit for you.

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