View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Plotting more than 32000 points on a chart

You can the fact that the chart will only use visible data in its plot so if
you have a Sequence column, you can apply a filter of "=MOD(A8,2)=0)" to get
every other row.
For that matter, you could maybe get away with every 10th row for a faster
display. Depends on your data and requirements.
Not sure how your situation would work, where you have too many points to
start with.

NickHK

"inquirer" wrote in message
...
NickHK wrote:
Is there any visible difference from plotting say every other value

instead
of all 59000 points ?

NickHK

"inquirer" wrote in message
u...
Further to an earlier post, I have about 59000 data points that I want
to plot on an line chart. The points for the x axis are sorted in
ascending order.
I can plot the first 32000 points ok as Series 1 but how can I then

plot
points from 32001 on so they plot on the end of series 1? I have treid
defining series 2 as 32001 onwards but these points do not plot on the
end of series 1, rather they start again at the origin.
Any help much appreciated
Thanks
Chris



Thanks for your reply Nick.
No, I have just been looking at that and seems as tho that is what I
will have to do.
To do this, will I have to extract every second point to another column
and then define that as the series or is there another smart way of
defining the series to take every second point?