Dear skilled excel users,
simple it sounds, but impossible it seems to be for me to solve.
Data:
I have monthly data values (snow height changes in millimeters) at different elevations (around 4800 meters).
Goal:
I want to display it in a scatterplot with the snow height change as the x-values und the elevation as y-values. Just as it is displayed in the graph in the attached xlsx.
Problem:
I would like to select the complete table and define the x and y axis values in order to look like the example table. I have found no way to do this but to choose for each single data series its name, x-range, and y-range. I have tables with hundreds of lines (data series), and defining it all manually would take me ... long. I'm sure there is some hidden way to achieve this in a few clicks?
Desperately appreciating any help!
Nico
Bookmarks