The steps below describe a way to recover an old functionality in Excel 2007 that just simply worked without issue. Step 3 will set you back an hour or so (assuming this isn't in the Help Pages, which take too long to load anyway). If you plot dataset 1 and add dataset 2, there's no problem (because the X-axis column is identical). Ideally, Excel would see that the headers for the X-axis columns have the same exact labels in all the datasets and treat the new points (in Step 3) as values to be accounted for within the same range of numbers as the previous plot. You plot this third dataset with Chart… -> Add Data by selecting your X-axis and Y-axis values (just selecting the columns). You've a third dataset for which the X-axis points have the same units, but different values.ģ. You've two datasets with the same X-axis values.Ģ. This issue came up for me when trying to generate some simple spectral overlays in Excel. – a secondary X-axis to plot new data on the same graph in Excel? My Scenario – Overlaying Two Spectra On The Same Graph – a new dataset with different abscissa values in Excel? – a second dataset to a plot in Excel with new X-axis values? – multiple plots to the same graph in Excel with different X-values but the same X-axis units? – data with two different X-axes to a single plot in Excel? If you found this page via google, I'm going to assume you were searching for something like the following questions (which I'm including below so that search engines find similar questions): It is my hope that newer versions of Excel don't have this thoroughly annoying problem (and if there's an obvious way I don't know about to make this happen in a single shot, feel free to drop a line). Posting a workaround to re-introduce a feature for Excel 2013 that I think was removed for some reason and for which information on Excel 2013 (OSX-specific) is impossible to find through google searches.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |