Create Charts

 

The charts which are created from the Main worksheet always depend on data of a CSVREPnn data sheet. The graphic below shows the parts of the Main worksheet which you can use to create the charts:

       The center part of the Main worksheet is the chart definition area. You can define charts manually by

Another option is to use a predefined chart definition. A pre-defined definition must be related to a specific CSV data file. The existing pre-sets show the extension of the CSV data file to which them apply:

The pre-defined sets are on the RANGE worksheet after row 150. By selecting a pre-defined chart definition all values are automatically set. You can then use it as is or modify it, for example if you want a different chart type. To create the chart you must again press .

       The CSV data sheet provides different columns. The column headers are listed on the left hand side together with the column letter and number. For defining the X- and Y-axes you must use these numbers and letters. For example the Time value which is suited as a X-axis value is contained in the third column. So you can either enter 3 or C for X-Axis in the center part of the Main worksheet.

       On the right hand side there are a couple of additional information sections. If you want to use classic colors for your charts, the “Colors” table provides the index numbers. If you want to create combination of different chart types you must use the abbreviations “Y-Axis Chart Type Values” for the changed chart type.

Examples: