I wrote a script to extract the data from the .txt file into .xslx and to draw the graphs. The script is that every new data set is extracted to the new sheet in an already existed .xslx file. The issue is that every time the script is adding the new sheet with the new data, the format of the previously created graphs appears to be lost (legend, axes titles etc.). How it can be changed, so I wouldn't have to set the format for all of the charts every time?
I wrote a script to extract the data from the .txt file into .xslx and to draw the graphs. The script is that every new data set is extracted to the new sheet in an already existed .xslx file. The issue is that every time the script is adding the new sheet with the new data, the format of the previously created graphs appears to be lost (legend, axes titles etc.). How it can be changed, so I wouldn't have to set the format for all of the charts every time?
Thank you very much!!