Hi all,
I have created the attached Gantt chart, loosely based on a template that I found somewhere else online. I have had some feedback from colleagues with desired amendments they would like to see added, and was wondering if anyone here could help out?
For context, this gantt chart is being used to plan an event in November. Just as a default, I have set all of the start dates as 01/06/17 and the end dates as 25/11/17 which is when the event is. These dates will obviously change as we input tasks into the table.
Questions:
1. Can a line marker for today's date be added onto the chart? I believe so looking at YouTube tutorials but if anyone can suggest something easy to implement that would be great.
2. For some reason, the start date on the legend entries axis starts on 06/03/2017. Is there a way to change this to 01/06/2017, as this is when the first task started? I cannot find a way to change this..
3. Is it possible to add vertical weekly grid lines onto the chart to give more of a visual overview of tasks requiring action by specific work weeks? A label per week (or at least fortnight) would be ideal (I don't mind users having to scroll across).
4. Is it possible to add dots to the chart to reflect meetings that will take place around the tasks? These meetings would ideally be able to be inputted into the table. As an alternative, perhaps meetings could be added instead of a task with the same start and end date and I would have to format the lines of the chart to ensure it is visible?
5. Can duration in column G be displayed as working days?
6. Finally, is it possible individually edit the text formatting of the Horizontal Category Axis Labels? I can only seem to find a way to change all text. Ideally, I would like to make the labels follow a similar format to the tables, so the overall sub-categories (e.g. Contracts, Stand content etc) stand out more from the rest (i.e. larger font, Bold, Underlined). What would be even better is if I could shade the background of these values to reflect the table on the left.
Sorry for the long list of requests, I am hoping that I can at least implement most of them without having to start over?!
Thanks
Bookmarks