Are you still on Excel 2003 (as per your profile)? If so consider a x-y scattergram instead of a plain line chart.
postscript to the above: I note that B2 doesn't look like a proper Excel date due to the lowercase f. Your dates will need to be proper Excel dates for both gebobs' and my solutions to work.
|