Dynamic Chart Error

[NM1st]

Hi Guys,

I have created a dynamic chart for multiple series. I have created this using the offset function and have named 20 ranges. The problem I have is that if only 19 of the 20 named ranges are populated it reads that the worksheet contains one or more invalid references.

Is there a way to stop this from happening?

Thanks!

 

[NM1st]

Resolved my own issue.

I thought the NA() function would work - still graphed it. All you need to do is hide the row and set an if function in VBA to hide rows with a 0 or NA