Chart colors with multiple datasets on one graph

Request For Enhancement, User feedback candidates for wiki
Post Reply
scienceyankee
Posts: 8
Joined: Sun Jan 15, 2017 3:11 pm

Chart colors with multiple datasets on one graph

Post by scienceyankee »

OOo's chart facility within calc uses colors to distinguish different datasets plotted on a single chart.

There is an obvious way of changing the default colors for this, but not for line patterns.

Using colors to distinguish lines in graphs has two problems: 1) about 10% of males are colorblind and 2) color printing is not universally available, e.g., few US public schools have color printers available to teaching staff, and tends to be more expensive when it is available.

So, how does one set the defaults to use different line textures to distinguish datasets in a graph vs different colors?
Apache OpenOffice 4.1.3
AOO413m1(Build 9783) Rev 1761381

Windows 10 Home
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Chart colors with multiple datasets on one graph

Post by Zizi64 »

Double click on a line - Data series - Line - Style
Chart linetype.png
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
scienceyankee
Posts: 8
Joined: Sun Jan 15, 2017 3:11 pm

Re: Chart colors with multiple datasets on one graph

Post by scienceyankee »

Yes, I can do that.

I want to reset the defaults, not go into every single chart every single time.
Apache OpenOffice 4.1.3
AOO413m1(Build 9783) Rev 1761381

Windows 10 Home
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Chart colors with multiple datasets on one graph

Post by Zizi64 »

Yes, I can do that.

I want to reset the defaults, not go into every single chart every single time.
There is a function for change the default colors of the chart:
Tools - Optons - Charts - Default colors
But there is not a menu item or other function to adjust the default linetypes for charts in the Calc application - if I know it exactly.


But you can

- create a template with a chart (charts) based on a predefined data range. You can adjust the colors and the linetypes of the created chart. Save the document as a template. Open this template when you want use the modified chart/s/. I suppose that you always use similar charts - if not, then you need create more than one templates.

- write a macro (or more macros) to automatize the adjusting procedure of the existing charts in an existing document. You must study the object oriented programming, and the API functions before you start to achieve this task. Yo need find the chart objects in a document, and get the properties of teh sub-sub-objects (e.g. the lines and the color/linetype property of a line...) Note: It is not a simple task...


...The last chance :
The AOO/LO are open source softwares. You can modity the source code, and you can build your own version with different default color/linetype of the charts.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply