how to add a second x axis with same Y axis value in one plot

#1 October 19th, 2005, 04:45 AM

I'm plotting a figure with Y axis (Amount of products) vs. X axis (time as
seconds). At the same figure, i'd like to add a second X axis, which shows
the time as hours. This axis can be on the top of the figure, or below the
exising X axis. Anyone has the idea how to add this axis? I researched the
help center, it seems we can only add a second Y axis, is this true?

#2 October 19th, 2005, 08:42 AM

Hi,

No, once you have data on the secondary Y axis you can then display the
secondary x axis. See here for explanation.
http://www.andypope.info/tips/tip008.htm

Cheers
Andy

Mike wrote:
I'm plotting a figure with Y axis (Amount of products) vs. X axis (time as
seconds). At the same figure, i'd like to add a second X axis, which shows
the time as hours. This axis can be on the top of the figure, or below the
exising X axis. Anyone has the idea how to add this axis? I researched the
help center, it seems we can only add a second Y axis, is this true?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Plot 2 variables on Y axis	nemme	Charts and Charting	1	March 18th, 2005 08:17 PM
Plot a line? Set dymanic axis Max min	Stan Altshuller	Charts and Charting	3	December 9th, 2004 08:04 PM
secundary X axis in an Arrhenius plot	bandjo	Charts and Charting	3	October 16th, 2004 01:20 PM
Is it possible to plot this kind of data in a (line) chart w/ preferred axis? How?	pgtr	General Discussion	4	September 15th, 2004 02:05 AM
How the heck do I plot 'my text' for the X axis? (instead of 1, 2, 3, 4 etc.)	Tushar Mehta	Charts and Charting	2	October 2nd, 2003 05:59 PM