Why does a combo chart loose its formatting and secondary axis choices

%3CLINGO-SUB%20id%3D%22lingo-sub-1352430%22%20slang%3D%22en-US%22%3EWhy%20does%20a%20combo%20chart%20loose%20its%20formatting%20and%20secondary%20axis%20choices%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1352430%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20had%20the%20experience%20on%20numerous%20occasions%20that%20a%20combo%20chart%20in%20excel%2C%20looses%20options%20selected%20-%20one%20series%20is%20column%20graph%26nbsp%3B%20and%20two%20series%20on%20secondary%20axis%20with%20a%20line%20graph%20option%2C%20however%2C%20this%20charting%20option%20does%20not%20seem%20to%20be%20stable%20as%20these%20selection%20options%20just%20disappear%20and%20wasted%20time%20is%20spent%20recreating%20these%20graph.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20please%20direct%20me%20in%20what%20it%20is%20that%20I%20am%20doing%20wrong%20with%20this%20charting%20option%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1352430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello,

 

I have had the experience on numerous occasions that a combo chart in excel, looses options selected - one series is column graph  and two series on secondary axis with a line graph option, however, this charting option does not seem to be stable as these selection options just disappear and wasted time is spent recreating these graph.

 

Can anyone please direct me in what it is that I am doing wrong with this charting option ?

 

Many thanks.

0 Replies