Hello and thank you in advance as always.
The spreadsheet I am working on has a Gannt chart or horizontal bar chart and depending on its designation on col 'D', the corresponding color should appear for its bar. For example:
The problem I am having is that as I insert rows to add entries, the bar color does not correspond correctly. I really appreciate any and all feedback!
Best, CQ
The spreadsheet I am working on has a Gannt chart or horizontal bar chart and depending on its designation on col 'D', the corresponding color should appear for its bar. For example:
- Baseline = Green
- Actual = Orange
- No Work = Red
The problem I am having is that as I insert rows to add entries, the bar color does not correspond correctly. I really appreciate any and all feedback!
Best, CQ