Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Charts are limited.
Mainly they do not accept calculated ranges (like for DataValidity e.g.).
In addition all the title elements (Title, Subtitle, Axis captions) are text constants.
The sheer data can be prepared in dedicated helper ranges of a sheet, but the size of the ranges, the chart type, the number of series ... all that needs to be fixed when the chart is created.

There are a few workarounds, by replacing chart titles with cell contents e.g, for the view/print. See this attached example.

Any parametrisation beyond that requires manipulation by user code, imo, and that code will not be exactly simple.

Hoping the user herself will be able to make useful use of this
Wolfgang

Charts are limited.
Mainly they do not accept calculated ranges (like for DataValidity e.g.).
In addition all the title elements (Title, Subtitle, Axis captions) are text constants.
The sheer data can be prepared in dedicated helper ranges of a sheet, but the size of the ranges, the chart type, the number of series ... all that needs to be fixed when the chart is created.

There are a few workarounds, by replacing chart titles with cell contents e.g, for the view/print. See this attached example.

Any parametrisation beyond that requires manipulation by user code, imo, and that code will not be exactly simple.

Hoping the user herself will be able to make useful use of this
Wolfgang

(Editing:)
Replaced the original attachment by a slightly enhanced one.