VBA to create multiple charts from table

**MSellers** · 08-04-2010, 08:29 PM

Hi,

I've been using Excel 2007 for awhile but am pretty new to VBA. I am trying to write a Macro that would take data from a table on one sheet and would create a line chart for each row. More specifically: the title would come from column B concatenating with column A. One data series would extend from column D to O and the other one would range from P to AA for each row. I would like to do it for the top 100 rows. Any help would be greatly appreciated!