Thread: Get chart to
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
RNW RNW is offline
external usenet poster
 
Posts: 4
Default 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: sco
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.