Ask Your Question
1

Basic Macro Recording for Charts [closed]

asked 2012-08-09 01:39:54 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 12:23:41.538935

2 Answers

Sort by » oldest newest most voted
0

answered 2013-03-06 12:26:29 +0200

qubit gravatar image

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.

edit flag offensive delete link more
0

answered 2013-03-06 16:53:19 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 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

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-08-09 01:39:54 +0200

Seen: 1,754 times

Last updated: Mar 06 '13