Data exceeds chart limits
 

I have a user using Excel 2000 on a Winxp SP2 machine. He is trying to
create a 2d chart, but has over 65000 datapoints, which exceeds the (I think)
32000 data point limit for a chart.

What would be the best way for him to handle this? (I am at a complete loss.)

Is there someway for the chart to grab, like, every 5th datapoint? Or, how
would he setup a macro to do that?

Any help would be appreciated...thanks!

Rebecca

Data exceeds chart limits
 

Nevermind - I figured it out myself using the OFFSET command. Thanks
everyone anyway!

Rebecca

"Rebecca" wrote:

I have a user using Excel 2000 on a Winxp SP2 machine. He is trying to
create a 2d chart, but has over 65000 datapoints, which exceeds the (I think)
32000 data point limit for a chart.

What would be the best way for him to handle this? (I am at a complete loss.)

Is there someway for the chart to grab, like, every 5th datapoint? Or, how
would he setup a macro to do that?

Any help would be appreciated...thanks!

Rebecca

Data exceeds chart limits
 

The first question that must be asked is whether the top 1000 points will
block out the bottom 64000. Showing every Nth point can be done, if the
points are tracing a time series. One way, assuming thee data is in a range
like C2:C60000 is to enter a formula in D2:

=offset(c1,row()*5,0)

and fill this down to about D12000, and plot these values.

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


"Rebecca" wrote in message
...
I have a user using Excel 2000 on a Winxp SP2 machine. He is trying to
create a 2d chart, but has over 65000 datapoints, which exceeds the (I
think)
32000 data point limit for a chart.

What would be the best way for him to handle this? (I am at a complete
loss.)

Is there someway for the chart to grab, like, every 5th datapoint? Or,
how
would he setup a macro to do that?

Any help would be appreciated...thanks!

Rebecca