 |
|
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tip Contents
Data Window
Column titles need to be included during a Cut, Copy or Clear -
- Hold down the shift key when selecting the appropriate command.
Creating a template of the data window through the use of the Stationary Pad feature of System 7:
- Customize the data window to suit your needs (column titles, formats, etc.).
- Save the data window.
- Select the file and choose Get Info from the File menu.
- Check the Stationary Pad option. This will allow you to open a copy of this data window.
The Integer format supports numbers within the range of -2147483647 to 2147483647. Numbers outside this range will not be displayed correctly.
- To display these numbers as integers, enter the values in a Double format, change the Format to Fixed, and set the Decimals to 0.
If you wish to save text files from another application in a format that KaleidaGraph will recognize and open directly, contact Technical Support in order to obtain a copy of the binary data format.
Plot Window
It is possible to display text above the markers through the use of Text error bars.
Log axes on Column plots - KaleidaGraph uses 1 as a baseline when plotting bars on a log scale (log 1 = 0). Data values larger than 1 will be displayed as usual. Values between 0 and 1 will be plotted from the baseline down to the value, so as to appear in the opposite direction. To have all bars facing the same direction, create the plot as a Scatter plot. In Plot Style, select bar as your Marker and use the Marker Size field to control the size of the bar.
The Stack Histogram plot does not have any options that enable you to plot the bars in the order they appear on the data sheet. The bars are always plotted according to their size, with the largest counts at the bottom.
- The only way to have all counts in the same order is to use the Bin Data command and plot the resulting data as a Stack Column plot. These plots always plot based on the order in the data window.
Formula Entry
The table command can be used in Formula Entry to interpolate values between data columns. If you have X,Y data in columns 0 and 1, and a new set of X data in column 2, you can use the table command to find interpolated Y values at the second set of X points. The command would be c3=table(c2, c0, c1).
Difference formula - The following formula can be used to calculate the difference between the current cell and the preceding cell, storing the results in a new column. Note: Before executing the formula, select all of the data except for the first row.
- c1=c0 - cell(index() - 1, 0)
To calculate a statistic on blocks of data (ex: mean of every 5 rows) use the following formula:
- cell(index() * n + offset, ocol) = mean([index() * (n-1):index() * (n-1) + (n-1), icol:
icol])
where n = the number of rows in the block, the offset is the number of rows down where the final result will be stored, ocol is the output column number and icol is the input column number.
Invert formula - The following formula can be used to invert the data in c0 and place it in c1.
- c1 = cell(n - index(), 0)
where n is the total number of rows in the data window. Any empty rows at the bottom of the original data will be placed at the top of the output column. These can be selected and deleted.
If you wish to take an input column and have every X rows stored in a separate column, use the following formula:
- cell(index(), int(index()/n) + (col + 1)) = cell(index(), col)
where n is the number of rows in each group and col is the output column number. Using this formula, the data will be in the same row as the original data. - cell(index() mod n, int(index()/n) + (col + 1)) = cell(index(), col)
where n is the number of rows in each group and col is the output column number. Using this formula, the data will be placed at the top of the data window.
Curve Fitting
Multiple independent variables or including column numbers as part of the curve fit definition.
- In order to do this, you need to use the table command. For example, suppose you plotted c0 as X and c1 as Y and wished to use the values in c2 as part of the curve fit definition (possibly as a second independent variable). Anywhere you want to use c2 in the definition, replace it with table(m0, c0, c2). To use the table command, the X column must be sorted and there cannot be any duplicate values.
If you want to display all of the data points, but only fit a certain section of the curve:
- Copy the data you want to fit and paste it into a new column. Then create a Line plot, using both Y columns of data. Hide the new variable by choosing No Markers and a Line Style of None in Plot Style (Plot Menu). Apply the curve fit to this variable. The curve fit will be displayed, but the second set of points won't be displayed.
- An alternate method (as reported by one of our users) is to mask the unwanted cells in the original column. Create the plot and apply the curve fit to the remaining data. Go back to the data window and unmask the cells. Go back to the plot, choose Plot Style, and click OK. The plot will be redrawn to include the unmasked cells, but the curve fit will not be updated.
A way to fit two different equations is to combine them in a single curve fit definition using the if-else operator. If you had two functions such that:
y = F1(x) for x < x1
y = F2(x) for x >= x1,
you could enter the following type of definition in the Define dialog:
((x < x1) ? F1(x) : 0) + ((x >= x1) ? F2(x) : 0)
To force a linear fit to go through a particular Y value at X = 0 you have to use the general fit. For example if you wanted to have Y=4 at X=0 you would use the equation:
4 + b * x;
in the general fit dialog. Similarly for Y=0 @ X=0 (the origin) you would use
0 + b * x;
Setting default font and font size for the curve fit equation table in v3.08 or later of KaleidaGraph:
- Choose the text tool from the tool palette and double-click on the table.
- Choose the proper font and size. a
- Select Set Defaults from the File menu. Place a check in the box next to Equation Labels and remove the check next to Standard Labels.
- Click OK. You will not see the changes take effect until the next curve fit is applied.
- When you quit KaleidaGraph, save changes to the Style so that these changes will be remembered the next time you launch KaleidaGraph.
 |
|
| 홈 | VersaTerm | KaleidaGraph | 기술지원 | 데모 다운로드 | 주문 | |
|