Hello everyone. Please help with making auto adjusting charts. There are 2 non adjacent columns of data. Ranges where data is located (b13:b30020) and (d13:d30020). Both columns have formulas, and data displayed there is resoult of calculations based on other columns data. So both columns,if have values present,its continuos[without gaps],otherwise cell are ("") and have only formulas.
I made simple [x:y] line chart based on both columns of data. Need to make charts auto adjustable to include cells that belongs to specified range (b13:b30020),starting from b13 and till last cell that have a value present[first that is ""]. Obvious solution offset/counta didn't work,becouse excel recognize cell with formula and without value as zero. I can't format them as a table. Any ideas that could help?
i use excel 2010. generic windows laptop.
I made simple [x:y] line chart based on both columns of data. Need to make charts auto adjustable to include cells that belongs to specified range (b13:b30020),starting from b13 and till last cell that have a value present[first that is ""]. Obvious solution offset/counta didn't work,becouse excel recognize cell with formula and without value as zero. I can't format them as a table. Any ideas that could help?
i use excel 2010. generic windows laptop.