Sep 15 2022 05:12 AM
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")-chtlen,1,'Progress'!$AI$1)
The formula basically looks along to the blue highlighted row below and counts along until it hits a blank cell then stops and the charts updates automatically whenever a new % is added to this blue row. The same formula is used for the date along the top too however obviously references the orange cells not the blue.
However, whenever I try and change the chart to use this progress named range (blue) instead of selecting the cells manually for the series, it doesn't seem to recognise the cells like the date one does.
Date dynamic chart: you can see the dates along the top highlighted in a green box when I open name manager and select the date dynamic formula.
Progress dynamic range: you can see the progress isn't highlighted in a green box when I open name manager and select the progress dynamic formula.
I also get the following messages when I try to change the current manual progress data in the series to the dynamic progress one:
Does anyone have any idea it's not recognising or identifying the data?
Sep 15 2022 05:38 AM
Sep 15 2022 05:41 AM
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?
Nov 01 2022 05:04 AM - edited Nov 01 2022 05:05 AM
fairly simple fix in the end, I'd referenced a different row and not realised till I read both your comments!