Copy from chart to chart

Hi there!

First off, let me point out libreoffice is really getting faster! Really appreciated!

At my work, we work a lot with charts. There’s a lot of copy and paste and it quickly becomes endless. So here’s a bunch of features that I would like to have.

Before I jump to the list, if you guys think it should be feasible through macros, don’t hesitate to say it! I’ll gladly jump on the job!

  1. copy format from chart to chart ( I would offer a pack of awesome beers for this one, really! )
  2. select many charts at once, for example to allow copy & paste of many charts at once
  3. align charts on the grid. small one, but it would be great
  4. when copying sheets, make sure the graphs on it are based on the resulting sheet, not the old one!

Again, thanks!


In relation with second point:

  • Click on every chart with shift key pressed, and copy / paste.

with the third point:

  • Grid options: Menu/Tools/Options/LibreOffice calc - Grid
  • Align: Click on every chart with shift key pressed, and right-click/alignment.

with the fourth point:

  • By copying the chart, retain the source cells.
  • By copying the sheet, change the source cells to the new sheet.


@ filo I trying to put an enhancement request forward for a default style of a chart. Please have a look at

How to create a default settings for charts in Impress - #3 by ROSt53

Feel free to add your comments / requirement or create a new one. Just please inform somehow that both requests can be linked.

@ROSt53, thanks!

Hi @filo,

For any features that aren’t present in the latest release, please file an enhancement bug and provide as much information about this new feature as possible. Don’t forget to mark your bug as an ‘enhancement’. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.