500 charts on a worksheet will hose your workbook. Here's a better way to
proceed.

Assuming S/N in column A, Height in column B, and Age in column C, labels in
A1:C1, and 500 records from row 2 through 501.

Put the same headers in E1:G1. In E2 enter any serial number. In F2 enter
this formula:

=INDEX(A2:C501,E2,2)

in G2 enter this formula:

=INDEX(A2:C501,E2,3)

These two cells will update as the value in E2 is changed. Make an XY chart
using F2 as the Y value, G2 as the X value (age as independent variable
makes sense, no?), and E2 as the series name. Fix the X axis so min=0 and
max = longest age. Fix the Y axis so min=0 and max = tallest height.

To make this work nicely, add a scrollbar from the Forms menu. Orient it
horizontally, set its min to 1 and max to 500, and set its link cell to E2.
Drag the scroll bar to step down the list of trees.

So what good is showing one single tree on a chart? How about plotting all
trees on an XY chart, then add a series as I've described above in a
contrasting pattern? Then you not only see the indicated tree, but how it
relates to all the others.

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


"George" wrote in message
...
Dear friends,

I have the following sample date from a forest inventory

Serial Number (1...500)
Height (e.g. 13)
Age (e.g. 120)

I need to create XY scatter charts for each row of data? Is it possible
using some code?

Thanking you in advance,

GeorgeCY