Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

enter image description here

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).

share|improve this question

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.

menu

share|improve this answer

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.Angled X Axis Chart

share|improve this answer
    
Thank you for your help, I added a sample of the data in the original post. I'm not quite understanding what you mean by having the angled X axis one of the data series. Could you please elaborate a little bit more? I am quite stumped on what to do. – Glen M. May 25 '12 at 14:01
    
@GlenM., did this work for you? Please let me know if you need any extra help on it. – dav Jun 1 '12 at 13:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .