Forum Discussion

Randeep Jaison's avatar
Randeep Jaison
Copper Contributor
Apr 11, 2018

Format Data Table Dynamic Range Not Working!

Hi,

 

I am not sure why dynamic range is not working with the Graph ----> Format Data Table ----> Label Option --- > Select Range --- > Values From Cells 

 

I am trying to use dynamic Range as defined in the name manger as "Roof_Outbound_ID", for some reason I am getting a warning "The Reference is not Valid"

 

Is it allowed to use a dynamic range in the label option for graph!!

 

Could you please clarify.

 

Please find the attachments.

 

Thanks.

BR,

J.Randeep

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Randeep,

     

    I'm not sure dynamic range works with labels. At the same time you may use static range like F4:F25 - if empty at the end of it that affects nothing.

Resources