[Solved] Record macro to modify chart dataseries

[AccessShell]

Please confirm that one cannot record a macro operating on a chart. Every time I try, it seems that I have been thrown out of the recording session.

I am trying to record a macro to modify the dataseries in a chart. The ultimate goal is to use the macro as an example for writing this in VB6.
This is easily done when using Excel. But as I have found out recently, Calc is very different.

Thanks for any help you can provide.

Edit: Changed subject, was Recording macros  Make your post understandable by others  -- MrProgrammer, forum moderator

[UnklDonald418]

Without more details, it would be difficult to say what is causing your particular problem.
Be aware that the OO Macro Recorder only records key strokes, any mouse action is invisible to the recorder.
Recorded OO macros use Dispatcher commands, unfortunately there is no documentation available for the Dispatcher.
Most OO macros are coded in Star Basic and make use of the API, but other languages like Python, JAVA and C++ can also be used. I doubt that VB6 will work.
The book "OpenOffice.org Macros explained" by Andrew can be downloaded from
http://www.pitonyak.org/oo.php
If you are going to try coding macros, an essential tool is the MRI extension. It can be downloaded from
http://extensions.services.openoffice.o ... ction-tool
Documentation for the MRI extension can be found at https://github.com/hanya/MRI/wiki
and a tutorial at
viewtopic.php?f=74&t=49294

[AccessShell]

Many Thanks. I will evaluate

[Villeroy]

What exactly are trying to do? Adjust the data ranges of your series?

[AccessShell]

Yes, but from VB6. Only for Pie charts. Line charts can be created with a far off future date nd the new data points automatically get updated.