Help With Graphs

  • Thread starter Thread starter Steve T
  • Start date Start date
S

Steve T

Are there any issues to be aware of when creating graphs that plot time
formatted vales?

I have 2 columns on a sheet. One contains date values and the other time.

Some Date Some Time
31/08/2002 03:25.4
26/10/2002 03:22.5
23/11/2002 03:17.3
25/01/2003 03:12.1
22/03/2003 03:14.4
26/04/2003 03:10.5
28/06/2003 03:10.5
29/08/2003 03:16.0
19/09/2003 03:12.1

If I select the data in these two columns and click on the chart wizard to
create a line graph and then finish, the output is a mess. I have to
manually reset the data series names, values and x-Axis labels to get the
output that I want.

This does not seem to happen with any other data type. Is there any way to
quickly produce the graph that I want?

Many thanks
S
 
Steve,

Since both columns have numbers (dates, and times), the Chart Wizard sets
both up as series (neither as categories). The Wizard guesses at what you
want. I think you'll probably have to manually set up the source data, as
you've done.
 
Back
Top