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?
meanwhile, i will investigate and provide a response tomorrow.
sorry, but...
-pmover
RE: Excel chart with multiple x axes?
RE: Excel chart with multiple x axes?
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?
Cory
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips Fora.