Help.rtf

{\rtf1\ansi\ansicpg1252\deff0\nouicompat{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil\fcharset0 Courier New;}{\f2\fnil Segoe UI;}{\f3\fnil\fcharset0 Segoe UI;}{\f4\fnil\fcharset2 Symbol;}}
{\colortbl ;\red192\green192\blue192;\red0\green0\blue255;\red0\green0\blue0;}
{\*\generator Riched20 10.0.19511}\viewkind4\uc1 
\pard\b\fs28\lang1033 General\par
\b0\fs22\par
Lines that start with a semicolon are comments. Blank lines, comments, and lines containing only commas are ignored.\par
\par
Lines of the format \highlight1\f1 Setting=Value\highlight0\f0  are settings. Extra commas on the end of settings lines are ignored.\par
\par
All other lines are treated as CSV data. The first line of CSV data will be used for the column headings. Column headings are required, and the number of column headings will determine the number of columns accepted in each row of data.\par
\par
You can edit the files in a spreadsheet. Put settings in column A and save the file as CSV.\par
\par
Values (for both settings and CSV data) must be quoted if they contain commas, e.g. \highlight1\f1 Setting="Info1, Info2"\highlight0\f0 . If you want a quotation mark, use two quotation marks in a row. For example, \highlight1\f1 "Data ""A"" and ""B"" are names"\highlight0\f0 . Note that Excel and most other spreadsheet programs will do this automatically when they export spreadsheets in CSV format.\par
\par
Values can contain special characters using a backslash sequence. \highlight1\f1\\n\highlight0\f0  is translated into a line break (useful for creating multi-line headers or for moving a header downwards). \highlight1\f1\\1\highlight0\f0  is translated into a \'b9 character. \highlight1\f1\\2\highlight0\f0  is translated into a \'b2 character. \highlight1\f1\\3\highlight0\f0  is translated into a \'b3 character. If you actually want a backslash, use two backslashes in a row to get one backslash in the data.\par
\par
The special value "--" (two hyphens) will cause the cell's text to be replaced with a horizontal line.\par
\par
Unless you've set the "skip" option for a row, you \b must\b0  set the \highlight1\f1 AverageColumn\highlight0\f0 , \highlight1\f1 LowerColumn\highlight0\f0 , and \highlight1\f1 UpperColumn\highlight0  \f0 settings. All other settings are optional.\par
\par
After updating settings or data, press \highlight1\f1 F5\highlight0\f0  to render the chart.\par
\par
\b\fs28 Settings\par
\b0\fs22\par
\b AverageColumn, LowerColumn, and UpperColumn\b0\par
\par
These settings are required. They indicate which columns contain the data for the plot. Column numbering starts at 0 (i.e. Excel's column A corresponds to this program's column 0). The \highlight1\f1 AverageColumn\highlight0\f0  will be rendered as the plot. The \highlight1\f1 LowerColumn\highlight0\f0  and \highlight1\f1 UpperColumn\highlight0\f0  will be skipped.\par
\par
\b GroupColumn\b0\par
\par
If you want a \i group \i0 column, set \highlight1\f1 GroupColumn\highlight0\f0  to the column you want used for group data. Column numbering starts at 0.\par
\par
Any non-blank value in the group column or a \highlight1\f1 GS\highlight0\f0  (\b g\b0 roup \b s\b0 tart) option in the \i options \i0 column starts a new group. A column with the value \highlight1\f1 !\highlight0\f0  in the group column or a \highlight1\f1 GE\highlight0\f0  (\b g\b0 roup \b e\b0 nd) option in the options column ends the current group.\par
\par
\b OptionsColumn\b0\par
\par
Sets options for the row. This column is not shown in the chart. Options should be separated by spaces. Options include:\par
\par

\pard{\pntext\f4\'B7\tab}{\*\pn\pnlvlblt\pnf4\pnindent0{\pntxtb\'B7}}\fi-360\li720\highlight1\f1 Diamond\highlight0\f0  - render the center point as an empty diamond instead of a filled box.\par
{\pntext\f4\'B7\tab}\highlight1\f1 Bold\highlight0\f0  - render the text of the row in a bold font.\par
{\pntext\f4\'B7\tab}\highlight1\f1 Dash\highlight0\f0  - render a dashed line through the center point of this row.\par
{\pntext\f4\'B7\tab}\highlight1\f1 Summary\highlight0\f0  - Same as \highlight1\f1 Diamond\highlight0\f0  + \highlight1\f1 Bold\highlight0\f0  + \highlight1\f1 Dash\highlight0\f0 .\par
{\pntext\f4\'B7\tab}\highlight1\f1 GroupStart\highlight0\f0  or \highlight1\f1 GS\highlight0\f0  - this is the first row of a new group.\par
{\pntext\f4\'B7\tab}\highlight1\f1 GroupEnd\highlight0\f0  or \highlight1\f1 GE\highlight0\f0  - end the current row's group.\par
{\pntext\f4\'B7\tab}\highlight1\f1 Background\highlight0\f0   or \highlight1\f1 BG\highlight0\f0  - the color to use for this row's shading.\par
{\pntext\f4\'B7\tab}\highlight1\f1 Foreground\highlight0\f0   or \highlight1\f1 FG\highlight0\f0  - the color to use for this row's lines and text.\par
{\pntext\f4\'B7\tab}\highlight1\f1 Skip\highlight0\f0  - Do not render a plot for this row.\par

\pard\par
\b ColumnWidth\b0\par
\par
The \highlight1\f1 ColumnWidth\highlight0\f0  setting can appear any number of times. The first appearance of this setting corresponds to the first column (column #0). Each subsequent appearance of this setting corresponds to the subsequent column.\par
\par
If specified as a number, the number indicates the width for the column in inches. A blank \highlight1\f1 ColumnWidth\highlight0\f0  means the width of the column will be automatically determined based on the minumum width needed to fit the column contents. For example, the following would cause the plot to use specific column widths for columns 2 and 4, but to automatically determine the column widths for all other columns:\par
\par
ColumnWidth=\par
ColumnWidth=\par
ColumnWidth=2\par
ColumnWidth=\par
ColumnWidth=0.5\par
\par
In general, most of the columns can be left as blank for automatic sizing. The \highlight1\f1 ColumnWidth\highlight0\f0  setting for \highlight1\f1 AverageColumn\highlight0\f0  will be used as the size of the plot (defaults to 4 inches). The \highlight1\f1 ColumnWidth\highlight0\f0  of \highlight1\f1 LowerColumn\highlight0\f0  will be the left margin of the plot (defaults to 0.1 inches). The \highlight1\f1 ColumnWidth\highlight0\f0  of \highlight1\f1 UpperColumn\highlight0\f0  will be the right margin of the plot (defaults to 0.1 inches).\par
\par
\b ScreenDpi, PrinterDpi\b0\par
\par
The \b D\b0 ots \b P\b0 er \b I\b0 nch to use when rendering the chart for the screen or printer. The default is 96 for screen and 600 for printer.\par
\par
For backward-compatibility, the setting "ImageDpi" is a synonym for "PrinterDpi".\par
\par
\b ScreenAntialias, PrinterAntialias\b0\par
\par
Set to 1 or Y to enable gray-scale font anti-aliasing for rendering the chart on the screen. The default is enabled for screen, disabled for printer.\par
\par
For backward-compatibility, the setting "ImageAntialias" is a synonym for "PrinterAntialias".\par
\par
\b ScreenColor, PrinterColor\b0\par
\par
If color is enabled, colors will render exactly as specified. If color is disabled, colors will be converted to gray during the rendering process. The default is to enable color for screen and to disable color for printer.\par
\par
For backward-compatibility, the setting "ImageColor" is a synonym for "PrinterColor".\par
\par
\b AverageAlign, LowerAlign, UpperAlign\b0\par
\par
Sets the Plot X value over which the Average, Lower, or Upper header will be displayed. The Average header will be centered over the \highlight1\f1 AverageAlign\highlight0\f0  value. The Lower header will be right-aligned over the \highlight1\f1 LowerAlign\highlight0\f0  value. The Upper header will be left-aligned over the \highlight1\f1 UpperAlign\highlight0\f0  value. For normal (linear) plots, these default to 0. For range (log) plots, these default to 1.\par
\par
\b VerticalLine\b0\par
\par
This setting can appear any number of times. If you set \highlight1\f1 VerticalLine=\i Number\highlight0\i0\f0 , you will get a vertical line from the X axis to the top of the plot at position X=\i Number\i0 . You can also set \highlight1\f1 VerticalLine=+\i Number\highlight0\i0\f0  (add a + sign before Number), in which case the line will extend into the column headings.\par
\par
By default, the line will be solid. To change this, add a semicolon and a line-type option: Solid, Dash, DashDot, DashDotDot, or Dot. Example: \highlight1\f1 VerticalLine=1.3;Dash\highlight0\f0 .\par
\par
\b RowHeight\b0\par
\par
This is the height for each row of the chart, in lines. Default is 1.5.\par
\par
\b HeaderRowHeight\b0\par
\par
This is the height for the header row of the chart, in lines. Default is 1.5. For two-line headers, set to 2.5.\par
\par
To make a header use more than one line, set the row height to 2.5 and use \highlight1\f1\\n\highlight0\f0  to specify the line break position.\par
\par
You can use a \highlight1\f1\\n\highlight0\f0  at the beginning of a header to move it down a line.\par
\par
\b LeftMargin, TopMargin, RightMargin, BottomMargin\b0\par
\par
The width of each margin of the chart (left, top, right, bottom) in inches. Default is 0.1 inches.\par
\par
Settings "LMargin", "TMargin", "RMargin", and "BMargin" are synonyms for "LeftMargin", "TopMargin", "RightMargin", and "BottomMargin".\par
\par
\b BackgroundLeftMargin, BackgroundRightMargin\b0\par
\par
The width of the margin to use for row shading, in inches. Default is 0 inches. Can be negative to have the row shading extend into the image margin.\par
\par
Settings "BGLMargin" and "BGRMargin" are synonyms for "BackgroundLeftMargin" and "BackgroundRightMargin".\par
\par
\b BackgroundTopMargin\par
\b0\par
The amount to move the row shading downward, in lines. Default is 0 lines. Can be negative to move the row shading upward.\par
\par
Setting "BGTMargin" is a synonym for "BackgroundTopMargin".\par
\par
\b RangeScale\b0\par
\par
How the range (X axis) should scale. The default is \highlight1\f1 linear\highlight0\f0 . Options include:\par
\par

\pard{\pntext\f4\'B7\tab}{\*\pn\pnlvlblt\pnf4\pnindent0{\pntxtb\'B7}}\fi-360\li720\highlight1\f1 Linear\highlight0\f0  - normal chart.\par
{\pntext\f4\'B7\tab}\highlight1\f1 Log\highlight0\f0  - ratio chart.\par

\pard\b\par
RangeMin, RangeMax\b0\par
\par
Lower and upper X values for the chart. Default is based on the high and low values of the data. For logarithmic (ratio) charts, both values must be greater than 0.\par
\par
\b TickInterval\b0\par
\par
How often should minor ticks be shown on the X axis of the chart. For linear (normal) range scale, this is a period and defaults to 0.2. For logarithmic (ratio) range scale, this is the number of minor ticks between each major tick and defaults to 10.\par
\par
\b LabelInterval\b0\par
\par
How often should major ticks (with labels) be shown on the X axis of the chart. For linear (normal) range scale, this is a period and defaults to 1.0. For logarithmic (ratio) range scale, this is a factor and defaults to 10.\par
\par
\b LabelFormat\b0\par
\par
Controls how the major tick labels should be formatted, e.g. how many significant figures to display. The default is G7, which means numbers will be shown in decimal or scientific notation (whichever is shorter) and with up to 7 significant digits. Refer to {\f2\fs20{\field{\*\fldinst{HYPERLINK https://msdn.microsoft.com/EN-US/library/dwhawy9k(v=VS.110,d=hv.2).aspx }}{\fldrslt{https://msdn.microsoft.com/EN-US/library/dwhawy9k(v=VS.110,d=hv.2).aspx\ul0\cf0}}}}\cf3\f3\fs20  and {\cf0\f2{\field{\*\fldinst{HYPERLINK https://msdn.microsoft.com/EN-US/library/0c899ak8(v=VS.110,d=hv.2).aspx }}{\fldrslt{https://msdn.microsoft.com/EN-US/library/0c899ak8(v=VS.110,d=hv.2).aspx\ul0\cf0}}}}\f3\fs20  for details on what can be used here.\cf0\f0\fs22\par
\par
\b LabelMin, LabelMax\b0\par
\par
Controls the labels at the lower/upper ends of the X axis. The default is \highlight1\f1 auto\highlight0\f0 . Options include:\par
\par

\pard{\pntext\f4\'B7\tab}{\*\pn\pnlvlblt\pnf4\pnindent0{\pntxtb\'B7}}\fi-360\li720\highlight1\f1 auto\highlight0\f0  - Put a label at the end of the X axis, then start labeling at intervals according to LabelInterval. If the closest interval label is too close to the label at the end, skip the interval label.\par
{\pntext\f4\'B7\tab}\highlight1\f1 end\highlight0\f0  - Put a label at the end of the X axis, and skip the first interval label, then resume labeling.\par
{\pntext\f4\'B7\tab}\highlight1\f1 interval\highlight0\f0  - No label at the end of the X axis. Only the interval label will be shown.\par
{\pntext\f4\'B7\tab}\highlight1\f1 both\highlight0\f0  - Put a label at the end of the X axis and also label normally at intervals.\par

\pard\par
\b Label\b0\par
\par
Text to display below the X axis of the chart.\par
\par
\b FontName\b0\par
\par
Name of the font to use for the chart. Default is Verdana.\par
\par
\b FontSize\b0\par
\par
Size of the font to use for the chart, in points. Default is 12.\par
\par
\b PenWidth\b0\par
\par
How wide should the lines on the chart be. Default is 1 (measured in points, which are 1/72 of an inch).\par
\par
\b BarPenWidth\b0\par
\par
How wide should the bar lines on the chart be. Default is 1 (measured in points, which are 1/72 of an inch).\par
\par
\b ArrowSize\b0\par
\par
How big should the arrows on the chart be. Default is 4 (measured in points, which are 1/72 of an inch).\par
\par
\b Background, Foreground, HeaderColor, LabelColor\b0\par
\par
Sets the color to use for background (the color of the paper) and foreground (the color of the pen). Color is specified in hexadecimal RGB: two hexadecimal digits for red, two for green, and two for blue. (Hexadecmial digits count 00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 0A, 0B, 0C, 0D, 0E, 0F, 10, ..., 99, 9A, 9B, 9C, 9D, 9E, 9F, A0, ... FF). So 000000 is black, FF0000 is red, 00FF00 is green, 0000FF is blue, and FFFFFF is white. 808080 is 50% gray.\par
\par
Note that by default, all colors are converted to gray for the printer image.\par
\par
Settings "BackgroundColor" and "BGColor" are synonyms for "Background".\par
\par
Settings "ForegroundColor" and "FGColor" are synonyms for "Foreground".\par
\par
\b\fs28 Rendering to Screen or Printer\b0\fs22\par
\par
There are two modes for rendering: screen or printer. Screens tend to use color, work with varying levels of brightness for each pixel, but have relatively low resolution (somewhere between 72 and 150 pixels per inch). Printers may or may not use color, tend to have very high resolution (600 pixels per inch or more), but don't directly support varying levels of brightness for each pixel (ink dots are either present or absent, so brightness can only be approximated via dithering).\par
\par
This program allows you to adjust settings so that the result is optimized for use with either a screen or a printer. The default screen settings are 96 DPI with anti-aliasing enabled for fonts and color allowed. This makes a low-resolution image with varying brightness for each pixel. The default printer settings are 600 DPI with no anti-aliasing and all color is replaced with gray. You can adjust the settings to use for printers and screens as needed (i.e. enabling color for the printer, or disabling antialiasing for screen images).\par
\par
Printer images will work on screen (e.g. for PowerPoint), but they aren't ideal. PowerPoint has to convert them from a high-resolution black-and-white image to a high-resolution full-color image (requires a lot of memory and processing), then scale it down in resolution to make it fit on the screen (decreases the image quality). The result will probably be slow, take up lots of memory, and will look a little bit muddy. So use screen images (low resolution but with different levels of brightness and with anti-aliasing enabled to make up for it) for screens when possible.\par
\par
Screen images will work on printers, but will likely have fuzzy or pixelated edges. The screen image doesn't have enough resolution, so the edges will be blocky. In addition, the printer has to convert the different levels of brightness into dot patterns. So use printer images (few levels of brightness, no anti-aliasing, but with high resolution to make up for it) for printers when possible.\par
\par
Use the "view" menu to switch between previewing the printer and screen images (e.g. to ensure that the colors look ok on the screen image and that the grays look ok on the printer image). Note that by default the zoom is set to "100% inches" which means the chart will look approximately the same size on the screen no matter what DPI the chart is rendered at. If you want to see the actual pixels being used to make up the chart, change the zoom to "100% pixels".\par
\par
\b\fs28 License\b0\fs22\par
\par
\par
}