secondary "x" axis

[Nahysa]

I need to add a secondary "x" axis. It seems like excel
have the option for a secondary "y" axis but not for "x".
Is there anything I can do??

 

[Paul Corrado]

Nahysa,

I would think that for the graph to make sense it would represent an overlay
of comparable information. (Both items have the same independent variable)
Stock prices and trading volume over time would be an example. These items
have the same independent variable (the x axis) and that is time and
different values for the dependent variable (the y axis). Prices & Volume

Possibly you could solve your dilemma by switching the axis of your graph
and putting the common variable as the x coordinates.

HTH

PC

 

[dvt]

I would think that for the graph to make sense it would represent an
overlay of comparable information. (Both items have the same
independent variable)

That's not always the case. I have plotted waveforms (independent variable:
time) and the spectrum of that waveform (independent variable: frequency) on
the same graph. That is not at all uncommon in my line of work, and it is a
chart that packs a lot of information.

See my reply to Nashya's other post with the identical question. Excel can
do it, but it's hidden pretty well.

Dave
dvt at psu dot edu