Hello,

I'm building an Excel-based tool that includes a Gantt chart. I've done it with a staked bar chart (see image below)

Capture.PNG

The issue I'm finding is that I need to have gridlines at the start of each month and I haven't found a way of doing it. I can adjust it manually, but the graph needs to automatically adjust if a new task is introduced and more gridlines are needed.

Any advice on how to do it?

Many thanks in advance!
-Carlos