Get chart to

I'm trying to set up a template that will enable people to graph test scores
given on various dates over a long period of time. This is designed to show
progress over time on these tests.

I've got a table of data with each column being a test, and each row a score
on a certain date.

The graph will have a line for each test, and there will the dates the tests
were given along the X axis. The Y axis will be the score.

To make it easy for the user, I want them to be able to enter the data (by
row) in non-chronogical order. For example:

Date of test: score:
7-5-2007 10
8-6-2008 20
6-4-2005 5

Is there a way to get the chart to put the dates along the X-axis in
chronological order?

Thanks.

If you want each discrete date listed in order, you need to sort the data in
the sheet, and use a line chart with a category scale chart (not date
scale).

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


"RNW" <RNW RemoveThis @discussions.microsoft.com> wrote in message
news:8E5261FF-DAC5-47A7-8ECC-318449132720@microsoft.com...
> I'm trying to set up a template that will enable people to graph test
> scores
> given on various dates over a long period of time. This is designed to
> show
> progress over time on these tests.
>
> I've got a table of data with each column being a test, and each row a
> score
> on a certain date.
>
> The graph will have a line for each test, and there will the dates the
> tests
> were given along the X axis. The Y axis will be the score.
>
> To make it easy for the user, I want them to be able to enter the data (by
> row) in non-chronogical order. For example:
>
> Date of test: score:
> 7-5-2007 10
> 8-6-2008 20
> 6-4-2005 5
>
> Is there a way to get the chart to put the dates along the X-axis in
> chronological order?
>
> Thanks.