Create chart from CSV with macro

[Jim Julian]

I have csv files going back ten years and most follow a fixed format.

I've been loading and graphing the data in a chart that overlays the data. I'm happy with this. This is the way I store the data and in odd format.

My recent effort to create a macro to do the job, failed.
The recorder does not include chart formatting or creation.
Disk I/O are also excluded. The recorded macro opens the chart tool and goes directly to the save dialog, when done.

Are there any tools for batch processing csv files in Open Office? I'm aware of grep and sed but neither creates charts.

Thanks.

[MrProgrammer]

My recent effort to create a macro to do the job, failed.

You will find examples of creating a chart with a macro in the Macros and UNO API forum where I moved your post. There is a Search this forum box at the top of that forum's page. Perhaps you can find a topic where the chart is similar to the one you want to create. I do not offer to help with writing macros.

Are there any tools for batch processing csv files …?

Perl and Comprehensive Perl Archive Network provide methods to read and write CSV. This processing is external to OpenOffice.

I'm aware of grep and sed but neither creates charts.

Gnuplot can create charts in batch. This processing is external to OpenOffice.
Gnuplot demo gallery

Summary: You do not need OpenOffice to create charts from CSV files. Questions about the usage of Perl or Gnuplot are beyond the scope of this forum.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.