It is possible but it requires some hard work. You have to make a dummy
series. I suggest to look into the example Andy Pope provides on his
principle, although you need to adopt the approach to your own conditions.
You also may like to make a dynamic range name, so yr chart auto-updates with
every fresh month. Many posts here how to do that.