litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Misc - XYChart

Syntax:
=XYChart(XPoints, YPoints [, Color])

Description:
Draws a XY scatter chart in the cell for the points given.

The points can be either a range of cells containing the data points (e.g. A1:A50) or an array of points entered manually (e.g. {1,4,3,5,2,6,4}). The color parameter is optional and can be used to set the color of the line. By default Color=1 (black). The color values are not restricted to the following (1=black, 2=white, 3=red, 4=green, 5=blue, 6= yellow, ...)

Example:

=XYChart(A1:A50,B1:B50)