I have many workbooks with the same column structure. I made a scatter plot using the same column of all these workbooks.
Now I would like to make a new plot using another column of all these different workbooks. I can do this manually using plot setup and manually replace every single dataset but I was wondering if there is a method to automate and speed up this process.
I tried to use the Duplicate (Batch plotting) option but it is not very straightforward.
I'm afraid that cannot be batched. But you can use the Plot Setup dialog to plot the same column from multiple datasheets together and copy-paste format (or loading template). No need to add/replace one by one.
Thank you for the post. I added this to our jira system ORG-22834 and will check with our developer if we can add it in future version.
Right now, if you don't have customization in scatter plot and just want to plot a scatter graph with another columns in different worksheet, using Plot Setup as the link you found is the best way.
And if you have customization in the scatter plot, you can save it as graph template first. Then again with no data selected in workbook, choose Plot: My Template: and choose the template you saved. It will open Plot Setup. U can use the same step to plot. The customization in template will be applied.