Question explained in the excel document,
Essentially I have two x columns of data and one y column of data, I need to have the graph produce two x axis. See Excel Attachment.


Thanks for reading !

Attached Files

QUESTION TWO X AXIS.xlsx (172.5 KB, 12 views)

Perhaps http://superuser.com/questions/18806...ontal-possible

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I'm using excel 2016, so that is of no use.

Is it like shown in the attached?

Attached Files

QUESTION TWO X AXIS_2.xlsx (170.9 KB, 8 views)

Hi Xor,
Firstly thanks for the help,
Yes that is essentially it, However I needed the top X axis in reverse order,
I have just now put it into reverse order so that is fine, The only problem is that the numbers are not lining up.

I need the 0.5 on the Top x axis to line up with the zero on the bottom x axis etc, so like X top and X bottom points lining up like so : ( I attached latest copy) Cheers.
0 0.5
0.05 0.475
0.1 0.45
0.15 0.425
0.2 0.4
0.25 0.375
0.3 0.35
0.35 0.325
0.4 0.3
0.45 0.275
0.5 0.25
0.55 0.225
0.6 0.2
0.65 0.175
0.7 0.15
0.75 0.125
0.8 0.1
0.85 0.075
0.9 0.05
0.95 0.025
1 0

Attached Files

QUESTION TWO X AXIS_2.xlsx (170.9 KB, 11 views)

I don't know if this is any better. If not, I have no further ideas.

Attached Files

QUESTION TWO X AXIS_3.xlsx (170.9 KB, 9 views)

You're welcome

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post