JugglerJAF
Active Member
- Joined
- Feb 17, 2002
- Messages
- 297
- Office Version
- 365
- Platform
- Windows
I've been asked by our new training manager to chart employee progress against training plan. There are multiple training elements, each of which can have up to 5 modules (some only have 2).
I'm thinking of setting up something like the image below, but can't figure out how to get each "box" to colour as each module is marked as complete (based on another column containing TRUE/FALSE for each course/module.
I created the chart below by setting a value of 1 (or N/A#) for each module and creating a stacked bar chart, then manually colouring it to give an example of the desired output, but I can't figure out how to do the data layout or create a chart to update automatically. I'm sure I'll need multiple columns overlaid on top of each other, but I can;t figure out how to keep a "gap" for any modules not completed.
Any suggestions greatly appreciated!
I'm thinking of setting up something like the image below, but can't figure out how to get each "box" to colour as each module is marked as complete (based on another column containing TRUE/FALSE for each course/module.
I created the chart below by setting a value of 1 (or N/A#) for each module and creating a stacked bar chart, then manually colouring it to give an example of the desired output, but I can't figure out how to do the data layout or create a chart to update automatically. I'm sure I'll need multiple columns overlaid on top of each other, but I can;t figure out how to keep a "gap" for any modules not completed.
Any suggestions greatly appreciated!