0
I have an y-axis and two x-axes, which are depending on each other. But this depencence is not taken into account in Excel 2010 and I can primarily move the secondary axis up and down the range by changing the upper and lower limits. How can I link the two axes so that the scaling of both matches each other (I see that I could [by eye] overlap the maximum and minimum data points by changing the secondary axis limits accordingly, but the data points inbetween do not match at all)? Moreover, how can I add a secondary axis label? Here's the file: https://www.dropbox.com/s/dd94769ehg1rq6m/worksheetSecondaryAxis.xlsx?dl=0
youtube link tutorial your file: https://drive.google.com/open?id=0Bw4aUkFXvXqXWVoyWklnamxQOVE – befzz – 2015-07-05T20:24:55.613
Thanks, this is a possible way. But I'd like to achieve a secondary x-axis (top) that is linked with the primary x-axis (bottom), with the scaling thicks at the same position and only one visualised data set. How is this possible? Even if it would mean to make a second data set transparent but with the primary and secondary x-axis linked it would help me much. – Lucas – 2015-07-06T19:03:24.577