Is anyone familiar with Gantt Charts? I found this on this site How to create a fully interactive Project Dashboard with Excel - Tutorial + FREE Download (chandoo.org) and I'm trying to create my own version inspired by this to track production. I tried to pull JO#s for every step in process from "INV To Be Kit" to "Packaging in Process" and then I wanted to match the JO# to the Customer or "Team" like Chandoo has on his sample this way I could filter the processes by customer. I wasn't able to pull everything over as you can see from the attached and wasn't able to match the customer to the JO# because the first formula came back with a spill error. I've never worked with a Gantt chart so I'm trying this out. I've been learning so much on here and I'm experimenting with a lot of new things to try and make my job easier and make myself more efficient in these busy times. Hoping someone might understand these and could provide some advice on how to create a functioning chart.
111.4 KB Views: 6