×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel chart with multiple x axes?

Excel chart with multiple x axes?

Excel chart with multiple x axes?

(OP)
I want to create a chart that has mulitple x-axes and one y-axis.  For example, I want to plot material strength versus temperature, so the y-axis is strength in megapascals, and the main x-axis is temperature in kelvins.  I would like one or two other x-axes for temperature in degrees Celcius and degrees Fahrenheit.  Can this be done with Excel.  If not, can it be done with Mathcad?  Thanks.

Cory

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.

RE: Excel chart with multiple x axes?

as far as i know, yes you can create charts with 2 x-axis and i have done it.  unfortunately, this pc does not have xl, so i'm handicapped in providing details.  check into the help system and see what is states.  also, investigate the custom charts for further input.
meanwhile, i will investigate and provide a response tomorrow.
sorry, but...
-pmover

RE: Excel chart with multiple x axes?

If you select the first data range (X & Y values) and start the chart wizard, then add another data range (New X & same Y values), then once the chart is completed, you should be able to add the second X axis.

RE: Excel chart with multiple x axes?

melone is right, it is a bit awkward though.
once you have all your data series in the chart, select the second series, and choose Format Data Series, Axis, Plot on secondary axis. Excel will generate a second Y-axis which is not what you want. Then, choose Chart | Chart Options from the menu, select the Axes tab, and check the Secondary X-axis checkbox (and uncheck the secondary Y-axis box, if you want).
Good luck.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: Excel chart with multiple x axes?

(OP)
Thanks, this answered my question.

Cory

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources