Scatter Plot nodes can not have more than 1 column as y variable. For your use case (to plot multiple y variables) you can use Line Plot. Plotly Integration has nice features so I recommend that one
As for your question currently I haven’t found possibility to have multiple y axis shown with any KNIME Line Plot nodes. You can use R or Python integration for that.