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:
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.
Last edited by Mordred; 12-23-2011 at 11:05 AM.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
Re: How to keep the LineType of One Series Collection While Other Collection Types Ch
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.
Bookmarks