Charts are complex objects with many properties.  The easiest way to
customize one with VBA is to create what you want the chart to look
like manually first but with the Macro recorder on.  You probably want
to select the maximum number of series that would actually be needed
so you can deselect some with logical IF's.  Then use the Macro code
as a template for your customization by replacing selected static
parameters with variables and ranges that you collect either directly
or indirectly from the user via a dialog box or something.

BTW, use range Names rather than cell addresses for the series.  Then
you can modify a range's dimensions without having to explicitly
update the code.

SteveM