Support Board
Date/Time: Thu, 06 Nov 2025 08:55:02 +0000
[Programming Help] - How to draw Horizontal line based on value in study spreadsheet
View Count: 1090
| [2022-09-14 08:06:31] |
| User361939 - Posts: 169 |
|
Hi, I have a value in spreadsheet and i want to draw horizontal line based on it. What study should i use to achieve this? Best REgards |
| [2022-09-14 15:54:42] |
| Sawtooth - Posts: 4285 |
|
The spreadsheet study can draw a horizontal line if the value is in one of the Formula Columns K-Z...BR.
|
| [2022-09-14 16:12:15] |
| User361939 - Posts: 169 |
|
Would you be kind and give some more detail? E.g Value for level is on K3, how can i automatically draw level? Color bar or color background studies works if condition is 1, here i have only Value. What i am missing? |
| [2022-09-14 18:38:49] |
| Sawtooth - Posts: 4285 |
|
You'll need to make the value absolute by preceding the row with $ in the formula, like this: =C$3 Then set the Draw Style to Line or Dash. |
To post a message in this thread, you need to log in with your Sierra Chart account: