Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Allow copying chart format / titles from one chart to another #47

Open
byronwall opened this issue Mar 4, 2016 · 3 comments
Open

Allow copying chart format / titles from one chart to another #47

byronwall opened this issue Mar 4, 2016 · 3 comments

Comments

@byronwall
Copy link
Owner

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
Copy link
Contributor

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
Copy link
Owner Author

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
Copy link
Contributor

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@byronwall @RaymondWise