If it's a line chart with a date scale, you don't need to sort the data. It
will be plotted left to right according to date, and the points will be
connected according to date, not according to order in the worksheet. An XY
chart will plot the points according to date, but connect them according to
order in the worksheet. See this blog entry for more information:

http://peltiertech.com/WordPress/200...d-line-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"RNW" wrote in message
...
Thanks, Jon.

I see what you are saying. It's not really important that each specific
date
be listed on the X-Axis. Only that the dates are in order to show progress
over time. So I've been using a date scale. You are saying that I have to
sort the data first. That's what I was hoping to avoid because I'm trying
to
set this up for people who may not be very computer savvy. There's no way
to
get Excel to sort the dates when it creates the chart?

Thanks.