wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 223
- Office Version
- 365
- Platform
- Windows
Hi all,
Using Excel M365.
How can I center the X-Axis label for irregular data? Some months have 4 weeks, some have 5 weeks.
The first series in the chart gives a visual cue for which bars in series 2 belong to each month.
I tried merging cells for each month, adding the label and choosing the column for the x-axis - but that did not help.
The label is still aligned left on the first data point for each month.
thanks,
lou
Using Excel M365.
How can I center the X-Axis label for irregular data? Some months have 4 weeks, some have 5 weeks.
The first series in the chart gives a visual cue for which bars in series 2 belong to each month.
I tried merging cells for each month, adding the label and choosing the column for the x-axis - but that did not help.
The label is still aligned left on the first data point for each month.
thanks,
lou