I am working on a spreadsheet that includes all the published numbers about the coronavirus pandemic. In it I have a sheet where depending on the user’s choice the data of one particular country is displayed including several in graphical form. Problem is the numbers of various countries differ very much, which means that the user must manually edit the graph’s scale for the Y-axis. Is there any way to have the graph automatically change its parameters depending on the data it is processing, or perhaps according to the value of some cell I define?
