Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Misc functions

Buy now

Download now

LITlib - Excel Power Functions Pack
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - XYChart function
litLIB Help
Product pages :
Quick links:
help index

Misc - XYChart

=XYChart(XPoints, YPoints [, Color])

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, ...)