Hi Peter,

You need a macro.

Loop through each row.
Build Chart.
Save Chart.

I have prepared a worksheet that does this and saved it in my charting page
at
http://edferrero.m6.net/charting.aspx look for 'Multiple Chart Builder'
(hint: its down the bottom).

The workbook saves each chart as a .gif file in a folder of your choice.

Ed Ferrero
http://edferrero.m6.net/

I am attempting to create a separate chart for each row of my worksheet
(about 300 rows = 300 separate charts). Is there an easy way to do this?
The actual data range will change month-to-month, so I would not want to
have to recreate 300 new charts each month individually.