Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
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 show you this lite weight In Cell Gantt Chart.
I have used formulas in conditional formatting to give a different color to Actual Days bar & Planned Days Bar.
This formula in first stage cell will give you a simple bar against the days planned. I have multiplied the days planned with 10.6 to properly adjust the bar in days cell.
This formula will enter the blank space for the days taken by the previous stage & create a bar for the day’s taken by the current stage. Here also, I have multiplied the days with 11 & 10.6 for adjustment. You can change these number as per your cell width.
Using REPT Function to Create an In Cell Gantt Chart in is a time saver compare to other ways for Gantt Chart. It has some limitation but you can use it if you don’t have some high demands. I really want you to give suggestions for improvement in this.