• Functions

  • ChartData()
  • ChartDataOptions()
  • ChartDataLowerLimits()
  • ChartDataUpperLimits()
  • ChartDataWrite()

• Function Groups

  • Axes
  • Backgrounds
  • Curve Fitting
  • Drop Lines
  • Error Bars
  • Grids
  • Legend
  • Moving Averages
  • Styles
  • Title
  • Functions by Group
  • Functions by Name

• References

  • File Path Syntax

ChartDataRead

ChartDataRead ( fileName ;​ doTranspose ;​ seriesSeparator ;​ elementSeparator )

Examples

Description

Instead of taking the chart values directly from FileMaker Pro via ChartData() they can also be imported from a text file. By using the 1st argument fileName the name of the file including an optional file path is defined. Please refer to File Path Syntax for the allowed syntax for file paths. As the default, the data is read row by row, i.e. a row corresponds to a data series. If the 2th argument doTranspose = on is used, the data is read in columns, i.e. a column corresponds to a data series. By using the arguments seriesSeparator and elementSeparator user-defined separators can be specified between the series and between the individual values. Unless otherwise defined, series are separated by a line feed "\n" and individual values by a tab character "\t". Decimal numbers can be entered using a decimal point or decimal comma; however, thousands separators and E-format are not permitted. The ChartDataOptions() function is ignored in connection with ChartDataRead(). Examples:

The ChartDataRead() function can be positioned as you like, but always within the OpenDrawing() and CloseDrawing() functions. ChartDataRead() can also be called repeatedly.