7.4

Data
l Skip lines with invalid data: Select to remove any empty lines or lines that do not contain valid integer, measure
or currency values from the data selection.
l Thousands separator: Enter the thousands separator the input data uses. PlanetPress Design requires this to
ensure it reads the input data correctly. It does not use this or any other thousands separator in the values it displays.
l Decimal separator: Enter the decimal point separator the input data uses. PlanetPress Design requires this to
ensure it reads the input data correctly. It does not use it as the decimal separator in the values it displays. Rather, it
uses a period as the decimal separator.
l Currency symbol: Enter the currency symbol the input data uses. PlanetPress Design requires this to ensure it reads
the input data correctly. It does not use this or any other currency symbol in the values it displays.
Colors
l Color list: Displays the colors the graph uses. Each entry you add to the list displays both a sample of the color and
the numerical value of the color in the color model you are currently using. Recall that you select the default color
model in the User Options dialog box. The order in which you organize the colors in the Color list determines the assign-
ment of colors to the lines, bars, or pie sections of the graph. PlanetPress Design cycles through the colors in the Color
list, starting at the top, and assigns colors to the lines, bars or pie sections of the graph.
Excel Graphic
See Excel Graphic.
Excel Graphic
Microsoft Excel graphics can be added to your PlanetPress Design documents just like any other PlanetPress Design business
graphic. Data selections are used to populate the graphics at runtime, so each document displays context-specific information,
such as stock prices or monthly expenses. Like other images, Excel business graphics can be moved or resized. At design
time, only a placeholder is displayed on the page (the actual graphics are generated at runtime).
This feature is only available for Optimized Postscript printing and for Windows Printing. Microsoft Excel 2000 or better must
be installed on the server running the PlanetPress Design documents (although only the Excel template is actually required to
design the PlanetPress Design document).
For each Excel business graphic you want to use in PlanetPress Design, you must create an Excel template file (see the exam-
ple below for more details). At runtime, PlanetPress Design uses this file to generate the graphic and to display it on the doc-
ument.
To add an Excel business graphic
l Create an Excel workbook:
l The first sheet in your workbook must include the sample data on which your graph will be based. The data dis-
played in the graph must appear in the first one hundred cells of the same column. Some of the cells may remain
empty, but no data should appear past cell number 100. These 100 cells must not have any special formatting
(use the standard formatting). You may add a table on the same sheet for the purpose of organizing your data ,
but any data included in that table should be referenced to your sample data cells.
l The graph itself must be placed on a new sheet. Any variable information appearing in the graph must be ref-
erenced to the sample data cells from the other sheet, or to cells from the table, but only if those cells are ref-
erenced to the sample data cells. If you use the Chart Wizard to create your Excel business graph, bear in
mind that at the end of the procedure, you should select the As new sheet option so as not to place the graph
on the same sheet as the sample data..
©2010 Objectif Lune Inc - 165 -