Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to add a second x axis with same Y axis value in one plot
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
|
|||
|
|||
how to add a second x axis with same Y axis value in one plot
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add drop lines at plot crossovers, swapping X and Y axis | Excel Discussion (Misc queries) | |||
Plot 2 variables on Y axis | Charts and Charting in Excel | |||
how do I plot on the z axis? | Charts and Charting in Excel | |||
How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel | |||
Plot a line? Set dymanic axis Max min | Charts and Charting in Excel |