Hello,I am Pete, and I'll be happy to assist with your question today.
The X-Axis for the second series of data will need to be reversed separately.
To do this, select the data series for the second X axis, then on the Format menu, click Selected Axis and select the appropriate check box to reverse the data.
Your suggestion doesn't appear to work or I'm misunderstanding fix. Maybe I have explained problem incorrectly. I tried sending image not sure if I did it correctly.
The second set of data does not have different X-axis values. The second series has a different Y-axis set of values. I have no problem plotting the two sets of data with the second on a second Y-axis. The x-axis at this point has values starting from 800 and increasing to 1400. When I select the x-axis to format and reverse data only the first set of data plots correctly to the reversed axis but the second series (using secondary Y-axis) doesn't change.
I think that you are going to need to add the data reversed for the second plot or resort it I haven't been able to download it yet give me a few hours to get to a computer that does it a little better.
this is an excel spreadsheet ?
It is Excel - 2010 I think. I resorted the X-axis data for the second series and although it is closer it is still offset. See new attachment.
No big rush just a perplexing problem.
hi I am sorry I lost track of this question till you just posted again
I need to move to another computer to look at it but that looks like a word file rather than excel
No it is an Excel file it is just captured in Word. I have attached the Excel file. If you click on the red graph and check the point coordinates you will see how it is not plotting correctly.