Data exceeds chart limits

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

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
 
Nevermind - I figured it out myself using the OFFSET command. Thanks
everyone anyway!

Rebecca
 
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
 
Back
Top