Displaying the current date on a chart in Excel
- Click on the chart to select it.
- Click on the "Layout" tab in the ribbon at the top of the screen.
- Click on "Text Box" in the "Text" section of the ribbon.
- Click and drag to draw a text box where you want the date to appear on the chart.
- Click inside the text box and type (without the quotes).
- Press Enter.
That's it! The current date will now appear in the text box on the chart. If you want to format the date differently, you can do so by right-clicking on the text box and selecting
"Format Text Box". From there, you can change the font, size, color, and other formatting options.
I hope that helps!