Hi!
R5zkdDR.jpg
As you can see on Before and After. a value in cell B4 can be selected from the dropdown list. Some of the ratios are percentages and others are numbers. I want the chart to adopt the changes in the formatting. I have mannually formatted the secondary axis to display percentages in the After sheet. I want the chart to dynamically change its formatting of the axis.
Bookmarks