Forum Discussion
Dynamic range can't be used in a graph
Hi, I have used the same dynamic maned range for 11 of these graphs, and only one is giving me problem. This is the formula =OFFSET('Progress'!$B$6,0,COUNTIF('Progress'!$C$9:$AS$9,">=0")-cht...
What is chtlen?
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
fairly simple fix in the end, I'd referenced a different row and not realised till I read both your comments!
