Nobody can help you if you don't describe your problem more fully.

Is it that you want the month to display on your chart? Try creating a
cell with the formula

       =TODAY()

then format it with the custom format "mmmm", so that it shows "July".

Now create a text box in your chart, and (this is the tricky bit) use
the edit bar to make the box refer to the cell you made. It's no good
just typing "=A1" into the text box itself, that will just show "=A1".

Now your text box should show "July" on the chart, and next month it
will show "August", and so on.