Is there a way to introduce a secondary horizontal axis into an MS Excel scatter plot chart? I'm using Office 2013 on a Windows desktop.
More specifically, I have a series of outputs Y. Each "Y" corresponds to two different sorts of inputs X1 and X2. Let's say X1 is meters, X2 is yards, and Y is .... something else. So, I want to plot Y so that each Y point is sitting right over its corresponding value of meters (X1) on the lower horizontal axis, and at the same time, each Y point is sitting right below its corresponding value of yards (X2) on the upper horizontal axis. Can this be done?
But please note: I have seen similar questions to this on this site but they either 1) deal with formatting axes that are already present, 2) deal with vertical axes, 3) deal with plots other than scatter plots, or 4) just don't have an answer. So please don't mark this as a duplicate unless you are sure you have found a true duplicate that has an answer. Thanks.