Hi,
Do you want a graph with two X scales, top X-scale is scaled by real numbers while the bottom one has the samw scale with top X but displayed as date values?
If yes, could you try the following steps?
1. Suppose your hour values and date values were stored in column B and column C of Book1 respectively.
2. Click New Graph button and new a standard graph. Right-click on the graph and select Layer Management to open the dialog.
3. Make Add Tab active, choose (Linked) Top X from the drop-down list of Type. And click OK to close this dialog.
4. Set the type of these two X scales as log. Please note that, their scale range (defined by From and To in the ScaleTab of X Axis dialog) is greater or equal than the data range of column B.
5. Active layer1 and type layer.x.ticksbydata$=book1_b
in the command window.
6. Active layer2 and type the same sentence as step 5 in the command window.
7. In order to show the upper X-scale as dates, pitch on the top X and double-click on it to open the dialog. Active Tick Labels Tab, select Tick-indexed dataset from Tyoe and choose [Book1]sheet1!C to Dataset. Click OK to close this dialog.
Thanks
Fay
Originlab Tech Sevice
Edited by - Fay_Guo on 02/26/2008 04:14:09 AM
