Issue 121648 - diagram scaling (max & step) & other diagram-parameters should be controlable by values in cells
Summary: diagram scaling (max & step) & other diagram-parameters should be controlable...
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-01-20 16:35 UTC by tommyads
Modified: 2013-12-26 11:37 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description tommyads 2013-01-20 16:35:29 UTC
If you have e.g. 3 bar-diagrams in calc on the same sheet, showing similar data, then you should use the same scale on the y-axis for the 3 diagrams so the viewer easily can compare the sizes and gets a feeling for the numbers.
This can only be done manually. Now suppose you add a new diagram or just a new bar to one of your 3 diagrams, this could mean you had to change all the scales, so that the new data fits on the one diagram.

Proposal: if you could (optionally) enter the scaling-parameters (maxvalue, stepvalue) for the x-axis and y-axis (and other diagram-parameters) into a cell of the sheet (or another sheet), and the 3 diagrams would fetch the values from these cells, this could save you a lot of time (if there are many diagrams in need for using the same scales).

Best regards!
Comment 1 Edwin Sharp 2013-12-26 11:37:04 UTC
Add an option to mark a chart "master chart" in sheet, so all other charts will have the same formatting.
Or add Chart Styles to Format - Styles and Formatting with existing Cell Styles and Page Styles.