Forum Discussion
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 ...
In a bar chart, the horizontal axis is the value axis. This is strictly numeric, it does not "know" whether it represents dates or not. Since months have different lengths, it is not possible to set the major unit to 1 month: January has 31 days, February 28 (or 29), etc. The nearest you can get is by setting the major unit to 365/12 = 30.416666, but you'll see discrepancies.