Need a bit more info. Can you post a sample of the data you have including
column headers etc?
What sort of chart do you want?
Do you need to be able to view all or multiple charts simultaneously. Under
some circumstances using AutoFilter allows you to create just one chart and
it becomes dynamic based on the AutoFilter setting.
If AutoFilter option used, do you have a column with unique values or titles
that would allow selection of a specific line of data. Alternatively would it
be out of the question to add a column and simply number from 1 to 150 and
use that to select the individual rows.
It is fairly simple then to write code to set the Autofilter and print each
chart if required.


--
Regards,

OssieMac