Change scale of X-axis to 1-month intervals on stacked bar chart
Hi,
I am making a timeline for some projects in Excel using a stacked bar chart, with the project names going down on the y-axis and dates going along the x-axis. I have managed to make the date axis have major intervals of 4 weeks, with 1-week minor intervals, but ideally I’d like the major intervals to be monthly – e.g each line is the 1st of each month.
I have followed guides online to try and do this, which have told me that in the “Format Axis” tab there should be an option to set the units and intervals to months, but for some reason this isn’t showing for me.
I will attach a scrubbed version of the excel document for reference.
Any help is greatly appreciated.
Hi, I am making a timeline for some projects in Excel using a stacked bar chart, with the project names going down on the y-axis and dates going along the x-axis. I have managed to make the date axis have major intervals of 4 weeks, with 1-week minor intervals, but ideally I’d like the major intervals to be monthly – e.g each line is the 1st of each month. I have followed guides online to try and do this, which have told me that in the “Format Axis” tab there should be an option to set the units and intervals to months, but for some reason this isn’t showing for me. I will attach a scrubbed version of the excel document for reference. Any help is greatly appreciated. Excel Example.xlsx Read More