Scatter and Stock plot on the 2 y-axes?

%3CLINGO-SUB%20id%3D%22lingo-sub-1714562%22%20slang%3D%22en-US%22%3EScatter%20and%20Stock%20plot%20on%20the%202%20y-axes%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714562%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20simple%20to%20plot%20different%20data%20on%20two%20different%20y-axes...%20if%20it's%20like%20scatter%20and%20bar%20plots%2C%20with%20two%20values.%20I%20am%20having%20trouble%20putting%20a%20stock%20plot%20(min%20max%20close%20%2F%20day)%20on%20top%20of%20several%20scatter%20plots%20(basic%20x%20and%20y).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20catch%20is%2C%20I%20can%20try%20to%20add%20a%20new%20series%20to%20my%20scatter%20plot%2C%20but%20it%20only%20lets%20me%20select%20two%20values%20for%20x%20and%20y%2C%20and%20I%20am%20unable%20to%20later%20change%20the%20data%20type%20to%20stock%20since%20it%20is%20greyed%20out%20and%20demands%20the%20min%20max%20close%20%2F%20x.%20I%20also%20cannot%20add%20a%20blank%20new%20stock%20series%20to%20the%20plot%20then%20select%20the%20data%20afterwards.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1714562%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

It's simple to plot different data on two different y-axes... if it's like scatter and bar plots, with two values. I am having trouble putting a stock plot (min max close / day) on top of several scatter plots (basic x and y). 

 

The catch is, I can try to add a new series to my scatter plot, but it only lets me select two values for x and y, and I am unable to later change the data type to stock since it is greyed out and demands the min max close / x. I also cannot add a blank new stock series to the plot then select the data afterwards.

0 Replies