Chart Functionality: use cells for chart options & titles

[Myndex]

There are a few aspects of CHARTS that would be very useful to be able to reference the data in a cell:

Titles - Titles based on a cell's contents. I am aware of the various workarounds, none of which allow the use of "save as image."

Axis Minimum, Maximum, Divisions, etc. - the "automatic" versions are less than desirable with poorly defined defaults (mainly leaving far too much empty space)

Data Range - If you have a set of data that changes in quantity, it would be very useful to have the range auto adjust as it "range adjusts to exclude end of range at 0". If the total data range was defined in a cell, it would be trivial to fix this.


thank you

A

[jrkrideau]

I think you would need to put in requests to the developers. This forum simply users helping users.

Alternatively, you may need to move to a more sophisticated graphing package. A fairly simple-to-use but sophisticated graphing package is Gnuplot.

[Zizi64]

You can to realize these tasks by your own macro functions or subroutines.
You need write your macros (instead of recording them), because the macro recorder has a very limited capability.
You need create the macro based on the API functions and procedures of the AOO/LO. API: Application Programming interface.
These macro will control the charts referenced by their names.

[Zizi64]

Here is a sample file with some embedded macro for modify some Chart properties.
Tha macro will get the Chart objects as Shapes, then check the type of the shape, and then modify the properties the properties of the OLE type Shapes based on the contents od some Named cells.


Note: The graphical objects have more than one names. One for the Shape, and an other for the embedded object in the Shape
The chart shape have Name and PersistName properties.

The sample file was created in the LibreOffice 6.2.8

Chart properties.ods

(25.07 KiB) Downloaded 86 times

[Zizi64]

Here is a new version of my sample file with more chart properties.

Install and use one of the existing object ispection tools like the XrayTool or MRI. I am using the XrayTool.

Chart properties.ods

(24.21 KiB) Downloaded 74 times

[Zizi64]

Refresh data ranges (by modifying the StartRow and EndRow parameter)

Chart properties3.ods

(28.82 KiB) Downloaded 73 times

[Myndex]

Refresh data ranges (by modifying the StartRow and EndRow parameter)

Chart properties3.ods

I love this! thank you this is very very helpful!

[Zizi64]

I never know about some properties and/or I never know the location of some properties of the charts located in the sample file.

But the XrayTool can list them. As you can see it in the grayed lines of the macro code beginning the 'xray word
Use an object inspection tool, if you want to work efficiently with the macros.