asked 2012-08-09 01:39:54 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
I am trying to use a macro to format an x-y scatter plot. The formatting is always very similar for each graph so if I could record my format with a macro once it would make life a lot easier. I know some basics about macros and can format a spread sheet fairly easily. My problem arises when I try to format a graph. The macro recorder will stop and when I run the macro it will create the graph with no formatting changes. How/ can I record a macro to format my chart in the chart edit mode?
answered 2013-03-06 16:53:19 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
An alternative may be to copy the chart and set the data ranges of the new chart to the new data, see http://ask.libreoffice.org/en/question/8346/set-default-formatting-for-calc-charts/#8358
Hi Anonymous,
It's possible that the macro recorder doesn't have any support for this type of interaction. Please take a look at the limitations described here:
Although the Macro Recorder may not be able to record the steps necessary to format a chart, it might still be possible to write such a macro manually.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-09 01:39:54 +0200
Seen: 166 times
Last updated: Mar 06
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
