ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Automatically updating charts (https://www.excelbanter.com/charts-charting-excel/174618-automatically-updating-charts.html)

David W. Murto

Automatically updating charts
 
I use spreadsheets to track monitoring data over time for sampling sites.
The left part of the sheet is used for the parameter name + min, max, and
avg. I have a dummy column (filled w/ asterisks) to separate the calcs from
the data. My formulas include the ast column in order to anchor the range
as I insert columns of new data. I am trying to graph the data and am
wondering if I can use the ast column as an anchor. It shows up as a zero
value. Is there any way to make the chart ignore that point?


All times are GMT +1. The time now is 06:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com