Hi everyone,
I need macro to save 6 charts which are in a sheet with some fields locked in. My requirement is that to save plotted charts in a new sheet such that it should copy the all charts into new sheet and if i make any changes to original sheet it shouldn't reflect in the saved sheet. Like this I want to save charts from original sheet making changes to fields into multiple sheets, It shouldn't reflect the previously saved sheets.
I have used macro to build the 6 charts in a sheet using set analysis in expressions.
Please help me to do.