| T O P I C R E V I E W |
| snbc |
Posted - 05/22/2003 : 10:39:37 AM
Hello,
I found some help on this using the search but I couldn't get it to work for me. I have a data set with the x column as dates, several y columns as fecal values and the last y column as rain data. the fecal values are only available for certain dates while the rain data is available for all dates. I am trying to label the x axis with the dates that the fecals were collected. I can't really think of a way to do this besides making text boxes for each of the dates. There must be some other way. Any help is greatly appreciated. |
| 1 L A T E S T R E P L I E S (Newest First) |
| Lorraine |
Posted - 05/22/2003 : 5:50:11 PM
Here's a simpler way of doing this rather than having to create text objects along the X axis. Although the following explanation might seem lengthy, the process itself is very easy, I just want to explain in detail each step.
First, insert a new column in your worksheet after your "fecal" column by highlighting the "rain" column and choosing Edit:Insert (choosing Edit:Insert will insert a column to the left of the highlighted column). Then doubleclick on this new column and set the Plot Designation to "Label." I will refer to this new column as "fecaldates."
Your worksheet would be set up as follows
Time(X) Fecal(Y) FecalDates(L) Rain(Y)
Now copy the data in your X column (time) and paste the time data into your 'fecaldates' column (highlight the column heading, then choose Edit:Copy, then highlight the column 'fecaldates' and choose Edit:Paste. So basically your time column and your fecaldates column contain the same data.
Now you would plot all 3 columns, fecal, fecaldates, and rain. You will notice labels next to the specific fecal data point in the graph window and regular X axis tick labels in time.
Double-click on the X axis tick labels. The Plot Details dialog box will appear and the Tick Labels tab should be active. Uncheck the Show Tick Labels box to disable X axis tick labels (we are going to use the data labels instead). Then select OK.
Now double-click on any one of the data LABELS (fecal dates) in the graph window. The Plot Details dialog box will appear with the Label tab active. For Attach to Axis choose "Bottom X." For Justify, choose "Center" and for Y Offset, enter -100. You can also choose a rotation for these labels if you wish. Then choose OK.
The labels are perfectly in line with the data points however you may want to turn the X axis tick marks off. I have emailed you an example OPJ file for you to have a look, and if you have any questions please contact me.
*** Note: You did mention that you have multiple Y columns for fecal data so you may want to create a column for Labels to the right of each fecal column. The project I am sending you demonstrates this example.
-Lorraine
OriginLab Technical Support
Edited by - Lorraine on 05/22/2003 6:12:05 PM |
|
|
