Forum Discussion
How to highlight specific data in dynamic charts.
Riny_van_EekelenThank you and I understand your solution now. As for my error ,I guess it is because my formula for the named range involving maximum, counts cells "na". Attached here is my file that show my error for your perusal.
Liphor See attached. Now, the chart looks at three dynamic ranges RF, rfMax and rfMin (in that order) for the data and a dynamic range "Year for the X-axis labels.
When you create new dynamic ranges, like "namax" in your last file, you need to follow the instructions precisely. I.e. include the sheet name and use absolute cell references (i.e. with the $ signs). When I looked at the reference for "namax" it point to cells in column AD and the range was 50 rows long, because you inserted the COUNTIF based on column O rather than just picking up the number in H2.
- Noted.Thank you.