Forum Discussion
Solved
Create 'incell' 5 day gant with diff colors to show office, home but working, not available
Hello! I'd like to create an overall manpower chart with coloured symbols to give an at a glance idea of whether the staff is 1. working from office (dark green) 2. working from home (light green...
I guess that's only with VBA programming. As variant the code will analyse the cell below, depends on combination of symbols combine Wingding font blocks with their own colors into one text and return it to your cell, formatting it as Wingding.
Hi,
You can create something like the attached and you won't need to have helper rows.
Hope that helps.
Kind regards
- Thanks N,
As Sergei mention, its 5 diff colors in 1 cell to represent the week. As I understood that shall be 5 different colors blocks in ONE cell which covers entire week. One cell - one week - 5 colors.
