Hello gurus,
I just want to seek yet another help with regard to creating a dynamic chart with named ranges.
As you can see in the attached workbook, I was able to generate what I want to achieve however, the problem surfaces as even the blank and formula-driven cells are also included in the chart plotting. I do not want these to appear, and leave those with values in the chart, as entries will vary depending on the selection (i.e. value on ='Filtered Table'!$A$1)
Chart Issue.xlsx
I have done my own research but the solutions are generic and are not addressing my unique concern.
Thanks in advance for your help guys.
Bookmarks