How to keep the LineType of One Series Collection While Other Collection Types Change

Hi all and Andy if you are looking,

I have left and right toggle arrows that toggle my chart types. Under certain conditions created by the user, there is a secondary vertical axis with one series collection that stands out from the other collection's values (eg: the values are percentage changes of the other values from the primary vertical axis. When I toggle my chart types, I eventually toggle from xlLineMarkers to the xlColumnClustered type. When this happens, I would like the secondary series collection type to remain a xlLineMarkers while the rest of the primary vertical axis types change to xlColumnClustered types. A part of the code I have to toggle is:

Please Login or Register  to view this content.

For Case 3 I tried to change the LineType of the series collection but I receive an error for my troubles (Run Time 438 Object doesn't support this property or method). Obviously I am going about this wrong so if someone can steer me straight on this I would be most appreciative.

A series does not have a LineStyle property. You need to set the ChartType property.

Please Login or Register  to view this content.

You always have all the right answers regarding charts. You are amazing Andy Pope! Thank you so much for that. The funny thing about using .ChartType is, I didn't try because I assumed that it would change the types of all collections. At any rate, this is now solved and I have to create a new thread for a new problem.