Login Page - Create Account

Support Board


Date/Time: Sun, 06 Jul 2025 19:25:32 +0000



Post From: Spreadsheet Help__How do I limit subgraph to current bar?

[2019-10-19 17:34:43]
Sawtooth - Posts: 4236
Can I trouble you to tell me in english what * Row()=3 * says/means?
Each spreadsheet row is a chart bar. The current bar is in row 3 and earlier bars are in rows below.

If you don't give the ROW function a cell reference between the parentheses, it returns its own row number.
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ROW_Function