Allow copying chart format / titles from one chart to another

[byronwall]

Would be nice to copy formatting and title details from one chart to another. This might include:

• Chart titles and formatting
• Axis titles and formatting
• Axis scale values (min/max/ticks/etc)
• Chart (Series) type and formatting information

This might copy some or all of the details based on user selection.

There are several ways to do this:

• Take the chart with desired formatting, copy it, and then update the Series ranges to match the desired ones.
• Take the chart to be changed and step through the different settings, adding them as desired from the source chart.

One issue with this is related to selecting the charts. This is related to #46.

[RaymondWise]

That's rough that you can't save custom styles for charts like you can for pivot tables - you have to create a template.

[byronwall]

Yea and I have had a bear of time dealing with templates that get set as the default for a Chart for all of Excel. It makes a mess of the series that exist along with the default existence of things like the ChartTitle, various Axis settings, etc. I've always used the default settings to avoid these issues, but it's inevitable that other folks have set things outside of the default. This is less of an issue on a utility add-in like this that does things in small chunks (and can just fail if something is not as expected), but it becomes a serious problem when building more advanced macros that expect to go start to finish under some conditions.

End Rant

[RaymondWise]

It's one of those things - for some reason it's a lot more difficult than we think it should be.