How can write a script to plot my data with two y-axes

I have a timeseries data with electrcity access ( in percentage and population) and finance per year. How can I write two scripts: one to plot the data in worksheets ending with _per and _pop with two y-axes with legends of the country names and different colors and the other script to plot the data in the worksheet ending with _fin again with the country name as legend.

Answer 1

[Jemima Pulipati]

yyaxis is used to create a chart with two y-axes.

You can refer to this example for plotting data using yyaxis.