VBA to choose line or column chart type for a series collection

[iayala]

Hello! I am pretty new at using macros, right now I am bit stucked as I am trying to build one that changes a specific series in a series collection and change it to column type if it is in line type and vicerversa.

I tried to do it with macro recorder, but it only changes the first series.

I would very much appreciate your help.