#1
|
|||
|
|||
Graph - Need a second X axis on the Top of Graph
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 ! |
#2
|
||||
|
||||
__________________
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 |
#3
|
|||
|
|||
excel 2016
I'm using excel 2016, so that is of no use.
|
#4
|
|||
|
|||
Is it like shown in the attached?
|
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
I don't know if this is any better. If not, I have no further ideas.
|
#7
|
||||
|
||||
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PPT Themes and AXIS Lines in a Graph | james.ALM | Excel | 0 | 08-25-2016 07:41 PM |
How to create a specific graph using 2 x-axis. (See picture) | AlexVickers012 | Excel | 2 | 03-23-2015 12:21 PM |
column clustered bar graph with a line graph as secondary axis | Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
Triple Axis Line Graph | sschultz0956 | Excel | 1 | 09-28-2010 12:39 PM |
how do I add data values in Col A into X axis on bar graph? | hazz | Excel | 1 | 04-27-2010 01:42 PM |