Horizontal axis automatically starting with earliest date in Gannt chart

mkuzner

New Member
Joined
Mar 14, 2014
Messages
11
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
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Dan_W

Well-known Member
Joined
Jul 11, 2018
Messages
986
Office Version
  1. 365
Platform
  1. Windows
Cannot access your sharepoint.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,043
Messages
5,835,088
Members
430,340
Latest member
xoxe1337

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top