Home >> Support Board

Support Board

Date/Time: Fri, 19 Apr 2024 13:36:04 +0000

How to Post a Message for Support

Post From: how to add a list of vertical lines to a chart?

[2018-10-18 15:36:25] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3973
Add the Spreadsheet Study study. -Set the Chart Region to 1. -Give it a name in the Spreadsheet Name field. -Set the Number of Formula Columns to 60. On the Subgraphs tab: -Set the Draw Styles of every subgraph to Background (or Background Transparent), with a width of 2. -Set the colors of every subgraph. -Click OK and OK. When the spreadsheet appears, go to Spreadsheet >> Add Sheet and give the added sheet a unique name, e.g. VertTimes -Use the dropdown in the upper left corner of the spreadsheet and select the chart's Sheet#. -Go to Spreadsheet >> Delete Sheet. -Focus the chart and go to Chart >> Recalculate. The chart's Sheet# will reappear. (The above substeps will put the added sheet always at the top of the dropdown list). Use the dropdown in the upper left corner of the spreadsheet and select the added sheet. -Put today's date in cell A1, e.g. 2018-10-18 -Cells B1 and C1 are column titles: Start time and End time, respectively. -Enter 1 in cell A2. -Put this formula in A3: =A2+1 -Focus cell A3 and go to Spreadsheet >> Copy Formula. -Highlight cells A4:A61 and go to Spreadsheet >> Paste. -Enter or paste your start and end times in columns B and C, respectively. Use the hh:mm:ss format. They do not need to be in any order. They, and cell A1, will need to be updated each day. Use the dropdown in the upper left corner of the spreadsheet and select the chart's Sheet#. -Put this formula in cell K3: =AND(INT(A3)=VertTimes!$A$1,FRACTIME(A3)>=VertTimes!$B$2,FRACTIME(A3)<VertTimes!$C$2) -Replicate this formula in columns L3:BR3, incrementing the row references of columns B and C of the added sheet, e.g. in L3: =AND(INT(A3)=VertTimes!$A$1,FRACTIME(A3)>=VertTimes!$B$3,FRACTIME(A3)<VertTimes!$C$3) Use attached chartbook and spreadsheet file as an example. Date Time Of Last Edit: 2018-10-18 19:17:31


Vertical Line at Time.Cht - Attached On 2018-10-18 15:22:55 UTC - Size: 29.97 KB - 423 views Vertical Line at Time.scss - Attached On 2018-10-18 15:23:09 UTC - Size: 37.21 KB - 363 views