Creating a Graph with Two X-Axes and Two Y-Axes with an Angled Secondary X-Axis

Question

I'm struggling to create a graph that is supposed to end up looking like this:

I have been able to graph everything except for the secondary x-axis at the top for temperature in degrees Celsius. Is this possible? I have the data points for where the modulus and loss factor intersect with each temperature line, but I do not have any other values regarding the temperature. If it can't be done, is there any way I could perhaps combine a contour graph with a scatter plot?

Thanks in advance

EDIT: Here's a little sample of the data that I have.

Loss Factor 
Reduced Frequency   Frequency      Loss Factor       Temperature
1.53E-03            1.92E+00         1.91E+07         50
4.85E-03            3.02E+00         3.00E+07   
9.89E-03            3.90E+00         3.87E+07   
1.80E-02            5.04E+00         5.00E+07
Modulus         
Reduced Frequency   Frequency   Dynamic Modulus Temperature
1.07E-03            4.49E+02    4.49E+09    
3.06E-03            4.67E+02    4.67E+09    
8.34E-03            4.86E+02    4.86E+09    
9.93E-03            4.86E+02    4.86E+09    
2.20E-02            4.82E+02    4.82E+09    
4.42E-02            4.87E+02    4.87E+09          50



    50 Degrees Celsius  
   Reduced Frequency    D. Mod.
    2.77E-01            1.00E+11
    1.00E-03            1.00E+07

You can see that I only have the points of intersection of the temperature lines and the modulus/loss factor. I also I have the points at the end of each temperature line in relation to the y axis (dynamic modulus) and the x axis (reduced frequency).

Answer 1

For the secondary axes you can see double set fo axes

• You can make your XY chart with both dataset.
• Then double click on one series, and on the Axis tab, select Secondary. It appears a secondary Y axis.
• Select "Chart Manu/Chart Options/Axes tab", uncheck the secondary Y box, and check the secondary X box.

Answer 2

Short answer is that it can't be done in Excel, as you described it in your question. Excel is limited to four axes-primary and secondary X & Y. However, there is often a way to trick Excel into doing what you want. Without seeing the data (a sample would be a huge help), I would consider setting up your standard X & Y axes, then plot your modulus, loss factor AND angled X axis as three data series. That will require that your data points be determined through formula based upon the standard axes which will probably require a fair bit of formula creativity-but the final result should have the appropriate appearance. Good luck!

EDIT: Based on your data, here's what I came up with (Excel 2010): There are three data series, the modulus (red), loss factor (green) and the temperature "axis" line (gray). The chart is an XY Chart, with both primary and secondary Y axes, a primary X axis and a "psuedo axis" which is really just a data series formated to look like an axis (two points with a line). To finish the chart, you'll just need to add all of your primary series points, and one series (two points each) for each temperature line you want to show.