I am requesting assistance with a chart of data (please see attached spreadsheet). In the attached, I have created a chart for the years of 1997, 2002, 2007 and 2011 with the corresponding values for the millions of tons of freight.
Next, I need to incorporate the values of the percentage change for each of the four years, with 1997 being the base year. I would like to axis on the right side of the chart to be values of 0.5, 1.0, 1.5 and 2.0. Thus, all 3 values (Import, Export, Domestic) would start at 1.0 for 1997, and then three separate lines (of different colors) representing the increase/decrease from 1997 (the values are in lines 10-12). For example, for "Imports", a dot would appear on the year 1997 for the axis value of 1.0. Then the line would go up to 1.19 for year 2002, up to 1.36 for 2007, etc. Same for 'Exports' and 'Domestic'.
Please advise if I am not being clear. I always have trouble adding another axis to an existing chart. So, please, in addition to performing the request, can you please advise how you did it so I can learn as well since I have always wondered how.
Thank you as always. Your team is always of great help.