MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Chart Titles (Still no solutions)


Posted by bob on June 18, 2000 11:01 PM


Posted by Ivan Moala on June 27, 0100 1:29 AM

Format A1 & A2 as text using the '
eg in cell A1 = '12/06/2000
in cell A2 = '23/06/2000
Your concat.....should then work
NOTE: Using calculations / formulas on these cells STILL works.


Ivan

Posted by Ivan Moala on June 24, 0100 3:09 PM


Bob
As a quick fix, I would suggest concatinating the
two cells referenced into one cell and then use this
cell as your reference Title.


Ivan

Posted by Bob on June 27, 0100 8:27 PM

Chart Title solution (In case you were following)

CONCATENATE("Scrap From ",MONTH(B2),"/",DAY(B2),"/00 - ",MONTH(D2),"/",DAY(D2),"/00")

I used concatenate like you suggested Ivan.
I suppose I could have used year(B2) but did not want four digits and didn't want to fool around with it anymore. Format A1 & A2 as text using the '

Posted by bob on June 26, 0100 9:12 PM

ERR