I have seen similar topics addressed in the past but never on a dynamic chart.
I have 2 columns of data updated automatically every 20 seconds from a gage. These columns are then graphed on a dynamic line chart. What I want to do is add an upper and lower limit line to the same chart.
I currently have code that when a value is entered fills in the columns to the right with both limits and this is then charted. This works great until I get several thousand (10000) rows of data. The sheet becomes a little slow and the file size is huge. I would like to add these constant lines to the chart based on a formula or some other method that doesn't require the value to be entered next to every data cell.
Any help is greatly appreciated. Thanks
I have 2 columns of data updated automatically every 20 seconds from a gage. These columns are then graphed on a dynamic line chart. What I want to do is add an upper and lower limit line to the same chart.
I currently have code that when a value is entered fills in the columns to the right with both limits and this is then charted. This works great until I get several thousand (10000) rows of data. The sheet becomes a little slow and the file size is huge. I would like to add these constant lines to the chart based on a formula or some other method that doesn't require the value to be entered next to every data cell.
Any help is greatly appreciated. Thanks