Center X Axis Label

[wsnyder]

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

 

[Jon Peltier]

You can get this effect if you include a column of labels for the weeks. I've used counting numbers 1, 2, 3, etc, but you could put whatever you want into that column.

 

[wsnyder]

Thanks Jon,

Works great!
lou