Mar 02 2022 12:09 AM - edited Mar 05 2022 02:45 PM
Hello,
In my sheets, I have charts with serie formulas refering to names , themselves being dynamic (with if fuctions to trigger certain data inside the chart). The issue is that when I save and reopen the file, the series in the chart gets converted to static series, breaking the link to the name ( so for example "=sheet1!serie" become a serie like this "={3464\3845\3087\2887\3507\3581\5225\5383\6044\6332\6635\7569\6839\6932\7747\7699\7803\7910\7882\7985\7906\7810\7807\8325\8678\8880\9367\9079\7882\7686\7983\8242\8329\8389\7823\7688\7635\7551\7925\8149\8793\9572\9740\10157\9724\9043\8033\8131\8290\7771\7845\7863\7952\9599\7642\6002\5719\5671\5858\5854\6343\6086\5228\5121\5505\4978\4862\5209\5145\5392\5304\5443\5313\4845}").
Is there an option to check or uncheck to avoid these auto-editings ?
Thanks for reading,
Clem
Mar 02 2022 06:45 AM
Mar 03 2022 05:54 AM
Mar 03 2022 06:08 AM
Mar 05 2022 02:43 PM
Okay, as every data is from the same doc, It'll be fine.
Thanks for the help,
Clem