Hi,

i need advice please. Am using office2003SP1 and i cannot understand
why i cannot see all my data in a series of charts.

The data i have is really simple - 2 columns with a description in row1
of each of them.

The process - i select all the data in the two columns then hit the
chart wizard button. Select a line graph, hit next, check that all the
data has been selected, hit next.
now the first thing that happens is that excel decides to use the
column names plus about 12 samples of the data. E.g. if the row1 name
was "bob" then the name of the chart becomes "bob4.3 5.6 55 77 66.5
33.4"
Why on earth does excel use the data in the title of the chart?

That's not so bad though i can manually edit that.

What the problem is...is that when i finish creating the chart i only
have those samples on the chart which fit on one viewable page in
excel.

Now i have about 6000 rows of 2 column data that i want to chart
against each other but i only ever see as many rows that fit on one
sodding page. I expected to be able to cycle left and right through
potentially hundreds of charts as the column of data used for the
x-axis is in fact time - and my sample period may be many hours long,
with each increment being 3 seconds.
all that excel shows me is the last 10 minutes or so of the sample
period.

I thought the limitation here was just the number of rows in excel -
65000 odd - so what am i doing wrong? Cell format?

Can anyone help me please?

Much appreciated.