LinkBack URL
About LinkBacks
Highlight weekends in a stacked bar (Gantt) chart (Excel 2007)
I have spent roughly 2 weeks trying to figure this out, downloading templates, watching videos, etc... so I apologize if this is a topic that has been answered a bunch, but I can't seem to find a solution applicable to this circumstance, which makes me feel really dumb, because this seems like it should be really easy.
Anyhow, I am scheduling some ongoing projects for work, and while my chart does account for weekends by way of the WORKDAYS()(Excel 2007 doesn't have WORKDAYS.INTL(), but it does have NETWORKDAYS()) function for it's duration, it would be really useful to see the the weekends/holidays on the chart, so as to make scheduling adjustments(a very common task for the application) more manageable. I feel like I am really close, like if I could plot the "Weekends" series on a secondary axis, it would just click, however that option is grayed out.
Here is a link to an example of my spreadsheet:
https://drive.google.com/open?id=1GZ...exSxXxM5ByEmGV
Here are my requests:
1a) How can I highlight the weekends in this chart?
1b) How can I force the "Weekends" series to fall underneath the rest of the charted series?
1c) Bonus question: Can this be done without setting every single day on the x-axis as an individual value?
1c+)Can the chart be set up in a fashion that its starting date can be set from a cell?
Finally, as a QOL request, how can I set this chart up so that the fill color of the "Duration" series is based off of the Horizontal(Category) Axis Labels of the "Task" series.
Thanks in advance!
Register To Reply
Bookmarks