Invalid Reference Error due to blank Dynamic ranges in a Chart

  • Hi,

    I have a chart containing multiple data series and the visibility of these data series is controlled by Active X control option buttons/check boxes (different combinations).
    Since its kind of plan verses actual data and for analysis some of the data series have to be dynamic i.e. can be compared with other data based on fixed time intervals.

    For dynamic named data series i am using =OFFSET($A$1,0,0,1,MATCH("",$A$1:$A$50,0)-1)

    Everything works fine until i start to un select any data series, (dynamic or fixed), the invalid reference error starts to pop up.
    I need to hide or suppress this invalid reference error.
    Whether using a formula or excel VBA.

    Kindly help.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!