Chart colors with multiple datasets on one graph

Request For Enhancement, User feedback candidates for wiki

Chart colors with multiple datasets on one graph

Postby scienceyankee » Sun Nov 26, 2017 6:00 pm

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
scienceyankee
 
Posts: 8
Joined: Sun Jan 15, 2017 3:11 pm

Re: Chart colors with multiple datasets on one graph

Postby Zizi64 » Sun Nov 26, 2017 9:13 pm

Double click on a line - Data series - Line - Style

Chart linetype.png
Tibor Kovacs, Hungary; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6061
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Chart colors with multiple datasets on one graph

Postby scienceyankee » Mon Nov 27, 2017 2:11 am

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
scienceyankee
 
Posts: 8
Joined: Sun Jan 15, 2017 3:11 pm

Re: Chart colors with multiple datasets on one graph

Postby Zizi64 » Mon Nov 27, 2017 8:33 am

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; LO4.4.7, LO5.3.7 on Win7x64Prof.
PortableApps, WinPenPack: LO3.3.0-LO5.4.2 and AOO4.1.3
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6061
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to User Experience (UX)

Who is online

Users browsing this forum: No registered users and 3 guests