Hi everyone, noob here.
I have a "master" Excel (2010) chart that automatically graphs data based on the selection of several drop-down menus, including error bars. I want to be able to run through all my variables, and save the charts individually while maintaining my ability to alter font sizes, etc. (So a simple paste-as-picture won't suffice.)
I know how to de-link the data series from the data source (using F9), but I cannot de-link the error bars from the data source. And, uh, I have no idea about VBA, so a non-VBA solution is preferred. Else, detailed VBA instructions will be required.
Does anyone know how to unlink error bars in a chart from the original data source?
Any help is greatly appreciated. Thank you.
I have a "master" Excel (2010) chart that automatically graphs data based on the selection of several drop-down menus, including error bars. I want to be able to run through all my variables, and save the charts individually while maintaining my ability to alter font sizes, etc. (So a simple paste-as-picture won't suffice.)
I know how to de-link the data series from the data source (using F9), but I cannot de-link the error bars from the data source. And, uh, I have no idea about VBA, so a non-VBA solution is preferred. Else, detailed VBA instructions will be required.
Does anyone know how to unlink error bars in a chart from the original data source?
Any help is greatly appreciated. Thank you.
