ok, so i tried the offset formula and it's fine, but it breaks down because when I add data, it's NOT to the right , im inserting a new column of data in column B...this causes the offset starting point (ie B$2$) to shift when I insert a new formula...therefore, the chart is NOt dynamic as it doesn't capture today's data (it'll capture from column C now, which is yesyerdays data, to the last column to the right)
how do I fix this??? and it's so annoying how you can't easily use named ranged for series chart data? it appears you need to have the workbook name BEFORE the named range? i manually typed in the workbook name , but is there a faster way to do this?
how do I fix this??? and it's so annoying how you can't easily use named ranged for series chart data? it appears you need to have the workbook name BEFORE the named range? i manually typed in the workbook name , but is there a faster way to do this?