Automatically create chart sheets from data table

Hello,

I have a data table and I need to create a chart from each row of data. Since I have over 300 records, I would like to be able to do this with VBA instead of having to do it manually for each record. Does anyone have any advice on how to do this? Unfortunately, I don't know too much about VBA, so this may be way too complicated for me.

Thanks,
AJO

Hello AJO,

From your post it sounds like you want to create a chart from each row. My question is will all the data be charted the same way i.e., bar chart, scatter plot, etc. If so you can reuse the same chart by having the user select the data to be plotted. Let me know how the data will be plotted.

Sincerely,
Leith Ross

Yes, the data will all be charted the same way, in a bar chart. (Or a pie chart, I haven't decided.)

Thanks