Text box in Chart/Sheet with Dates

  • Thread starter Thread starter Wheelman
  • Start date Start date
W

Wheelman

Is it possible to insert a text box or other method for pulling dates
onto a chart? I have a spreadsheet that lists dates of requests in a
column and would like to show the starting (MIN) date and the ending
(MAX) date of the requests that are tallied in a chart as some part of
the heading. I can get MIN(mm/dd/yyyy) and MAX(mm/dd/yyyy) but can't
put them together into the heading or a text box, e.g., (Starting date)
through (Ending Date). Also, I've tried the CONCATENATE function and
then referring to that cell but it changes the formating on the dates.
Thank-you for the help. :)
 
Create the formula on your worksheet, e.g.:

="From " & TEXT(MIN(A2:A38),"mm/dd/yy") & " to " &
TEXT(MAX(A2:A38),"mm/dd/yy")

Then, click on the chart to select it
Type an equal sign -- you'll see it appear in the formula bar
Click on the cell that contains the formula
Press the Enter key.
Move the textbox to any location in the chart area, and format it.
 
Back
Top