String as Charts Category data

Hi,

I am trying to set category data to Day;Night but am getting exception
I also tried “={” + ““Day”” + “\” + ““Night”” + “}” but this turns into this Day""Night

Excel uses following format ={“Day”“Night”} or Day;Night

Do you have a suggestion what format should I use?

Thanks & Regards
Ranko

Hi Ranko,

I think you may try:
= “{“Day”,“Night”}” if it works fine for your requirement.

Thank you.

Hi Amjad

Yes that helped

Thanks & Regards

Ranko