Chart limit?

[man.or.fish]

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.

 

[bj]

I don't really understand your problem, but have you concidered using the XY
chart rather than the line chart?
in your <chart><source data>
what does the values formula say?

 

[man.or.fish]

thanks for the reply. I know it's a bit tricky to explain. Let me try
again.

The situation is taking performance data from performance monitor in
windows. So therefore i can have an x-axis which represents time, and a
y axis representing the the value of the counter at every time
interval, which in this case is every 2 seconds.

So, given that the sample period is several hours long, i have about
6000 rows of data.

What i would really like are multiple line graphs for the overall time
period so that, yes, i may have to scroll through a lot of different
charts but at least the data is nicely spread out. The first chart may
be minutes1-5, the second 5-10 and so on....without have to manually
select a small portion of the data, then hit chart wizard, then do it
again and again and so on...?

Or do i have to force a very large scale on the x (time) axis so that
EVERYTHING is displayed on the one chart and it makes disection of the
results tricky??? For instance i need the granularity of looking a a
time period of a few seconds and displyaing it to a client.

At present when i select all 6000 rows and do the chart wizard, it only
ever creates a chart for about 5 minutes' worth of data (ie 30 rows or
so), rather than multiple charts for the entire sample time period (the
6000 row selection that i made prior to selecting chart wizard).

I can respond directly to your question when i get back into work
tomorrow.

Cheers.

I hope this is clearer - apologies if it's not....

 

[Jon Peltier]

Could you make use of this example:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

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