Hello lovely people of MrExcel forum,
I have a question regarding Gannt chart I created in Excel. As Gannt charts do, it shows progress of planned and actual tasks in a period of time.
The problem I have is that I have to manually set the date that horizontal axis starts with. My idea is that it should be depended on the earliest date I write in my data for the graph (first planned or actual start date). At the moment, when I change my data, horizontal axis doesn't change and it would be a fantasy to achieve that.
Hope I explained it well. I am also attaching an example. You can download it here: https://lusb-my.sharepoint.com/❌/g/...ZOuiFljFyhr8IBh0ASMPgXBK3GKMTzhmJ0Xg?e=NVQ3PM
Thank you for your anwsers in advance. Should there be any additional questions, don't hesitate to ask.
Marko
I have a question regarding Gannt chart I created in Excel. As Gannt charts do, it shows progress of planned and actual tasks in a period of time.
The problem I have is that I have to manually set the date that horizontal axis starts with. My idea is that it should be depended on the earliest date I write in my data for the graph (first planned or actual start date). At the moment, when I change my data, horizontal axis doesn't change and it would be a fantasy to achieve that.
Hope I explained it well. I am also attaching an example. You can download it here: https://lusb-my.sharepoint.com/❌/g/...ZOuiFljFyhr8IBh0ASMPgXBK3GKMTzhmJ0Xg?e=NVQ3PM
Thank you for your anwsers in advance. Should there be any additional questions, don't hesitate to ask.
Marko
