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: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.
Please Login or Register to view this content.