Skip to Content (Press Enter)
Post Closed
UserImage.jpg
Andre Medeiros
4582Views
22Comments
Solved
Chart Colors
Question
Hi, im using the bar chart and put the customize color in the bars, but the indicator data series name dont appear in the same color of the bars, 

The example attached show the bar in "yellow"  and the indicator in "blue"

Thanks
Capturar.PNG
0
0
05 Sep 2014
Copy Link
2016-04-21 20-09-55
J.
 
MVP
Solution

Hiya,


using the advancedFormatInit.

add per series an record to the advancedseries_format.

simply do

name : your series name

seriesJSON: "{color: #ffd900}"

see attached oml for the example


See solution in context
ChartColor.oml
5
0
22 Sep 2016
Copy Link
2023-04-28 15-56-03
inesp

J. wrote:

Hiya,


using the advancedFormatInit.

add per series an record to the advancedseries_format.

simply do

name : your series name

seriesJSON: "{color: #ffd900}"

see attached oml for the example


That worked! Thanks a lot J.!


0
0
22 Sep 2016
Copy Link
UserImage.jpg
Capstone Project

J. wrote:

Hiya,


using the advancedFormatInit.

add per series an record to the advancedseries_format.

simply do

name : your series name

seriesJSON: "{color: #ffd900}"

see attached oml for the example


Hi,

I used this in bar and line chart, and it works fine. But in pie and donut chart, it doesn't work. So I thought AdvancedDataSeriesFormat alone doesn't work so I tried to add AdvancedDataPointFormat with DataPoint_Init in action. But still doesn't work. What will I do to change colors of my pie and donut charts?

Thank you.


0
0
28 Jan 2018
Copy Link
2015-10-23 10-13-31
Venkatesh Gude
Andre,

You can check below two places to appear..

1) Just check whether your label property is assigned ot not? 
2) In the properties of Graph add a text whatever you want to display before Tooltip value.
Hope this will helps....

Regards,
Venkatesh 
0
0
05 Sep 2014
Copy Link
UserImage.jpg
Steve Meyer
Blue is the Highcharts default color for the first series, so if you have overridden the series/bar color to be yellow then you may also have to reset the legend color separately.  I don't see specifically how to change that as a setting in the Highcharts API (it shows background color and border color for the legend), but I believe the legend series line color is related to the 'point' color that controls the tooltip border, etc. 

If I want the tooltip and the series color to match I find that I have to set the 'series' color in the dataseries itself (using the 'color' field of the DataPoint structure) and make that the same as what I have set the series color to be using the AdvancedFormat property of the chart.  It's an extra step but it makes sure that the default color scheme in Highcharts is not used when customizing the series colors.

Hopefully that makes sense... if not then let me know and I can try to post more detail.

Best regards,
Steve
0
0
09 Sep 2014
Copy Link
2018-01-22 14-25-08
David Zangger
We are running into the same thing.  Using a bar chart yields incorrect legend colors.  If we use a pie chart, the legend colors are just fine. 



Any easy way to fix this?  The help in the above posts aren't enough to help us fix the problem.

Thanks.
0
0
19 Mar 2015
Copy Link
UserImage.jpg
Faisal WaheedUllah

David Zangger wrote:

We are running into the same thing.  Using a bar chart yields incorrect legend colors.  If we use a pie chart, the legend colors are just fine.



Any easy way to fix this? The help in the above posts aren't enough to help us fix the problem.

Thanks.

How did u do this 

please explain in detail 

fast

 

 

0
0
22 Jul 2020
Copy Link
2020-03-05 15-52-45
André Vieira
Staff
Hi David,

Can you post the code for your chart, both the code in OutSystems and the generated javascript in the page would be very helpful.
0
0
20 Mar 2015
Copy Link
2018-01-22 14-25-08
David Zangger
Hi Andre - Not much to add.  Here is the SQL.

SELECT  {Task}.[Owner_Email], count(*), 'Task Ok', '', '#088A29'
from {Task}
where {Task}.[Owner_Email] IN (@EmailList) and {Task}.[Deadline] > sysdate
group by {Task}.[Owner_Email]
    Union
SELECT  {Task}.[Owner_Email], count(*), 'Task Overdue', '', '#8A0829'
from {Task}
where {Task}.[Owner_Email] IN (@EmailList) and {Task}.[Deadline] <= sysdate
group by {Task}.[Owner_Email]

We use DataPoint_Init using the values from query and then a ListAppend.  This list is then used by the bar chart.
0
0
20 Mar 2015
Copy Link
2020-03-05 15-52-45
André Vieira
Staff
Why don't you use DataPoint structure as the output of the Advanced Query? If that's what you have you don't need to use the DataPoint_Init action...
0
0
20 Mar 2015
Copy Link
2018-01-22 14-25-08
David Zangger
Andre, we do use the DataPoint as the output structure of the query.  I'll try remove the _Init and see what happens. 

-> I removed the _Init and code works great; legend is still not right.
0
0
20 Mar 2015
Copy Link
2020-03-05 15-52-45
André Vieira
Staff
Ok. Besides the DataPoint List what other information do you have on your chart. Can you paste here the generated javascript?
0
0
20 Mar 2015
Copy Link
2018-01-22 14-25-08
David Zangger
Andre, is this what you need?
andre.txt
0
0
20 Mar 2015
Copy Link
2023-04-28 15-56-03
inesp

Is there a solution yet? I'm having the same problem 


0
0
21 Sep 2016
Copy Link
2016-04-21 20-09-55
J.
 
MVP

You are setting your colors on the point level instead of the series level.

This leaves the series colors as the Highcharts default colors despite your column being the color you wanted.

The series color is what determines the legend icon color.

-> https://jsfiddle.net/jlbriggs/8xo2jayg/

-> https://api.highcharts.com/highcharts/plotOptions.series.color

1
0
21 Sep 2016
Copy Link
2023-04-28 15-56-03
inesp

Hey J.

But is it possible to manage that color using some outsystems attribute? The DataPoint_Init action allows me to choose the color for a certain point, I got that now, but how do I manage the series color then?

Thanks

0
0
22 Sep 2016
Copy Link
2016-04-21 20-09-55
J.
 
MVP
Solution

Hiya,


using the advancedFormatInit.

add per series an record to the advancedseries_format.

simply do

name : your series name

seriesJSON: "{color: #ffd900}"

see attached oml for the example


ChartColor.oml
5
0
22 Sep 2016
Copy Link
2023-04-28 15-56-03
inesp

J. wrote:

Hiya,


using the advancedFormatInit.

add per series an record to the advancedseries_format.

simply do

name : your series name

seriesJSON: "{color: #ffd900}"

see attached oml for the example


That worked! Thanks a lot J.!


0
0
22 Sep 2016
Copy Link
UserImage.jpg
Capstone Project

J. wrote:

Hiya,


using the advancedFormatInit.

add per series an record to the advancedseries_format.

simply do

name : your series name

seriesJSON: "{color: #ffd900}"

see attached oml for the example


Hi,

I used this in bar and line chart, and it works fine. But in pie and donut chart, it doesn't work. So I thought AdvancedDataSeriesFormat alone doesn't work so I tried to add AdvancedDataPointFormat with DataPoint_Init in action. But still doesn't work. What will I do to change colors of my pie and donut charts?

Thank you.


0
0
28 Jan 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

@mariap, could you mark J's answer as the Solution? Thanks!

0
0
23 Sep 2016
Copy Link
2023-04-28 15-56-03
inesp

Kilian Hekhuis wrote:

@mariap, could you mark J's answer as the Solution? Thanks!

Kilian, I can't, I am not the "owner" of the original post


0
0
23 Sep 2016
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Ok, appologies, I didn't check that. My bad.

0
0
23 Sep 2016
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Capstone Project,

First, let me advise you to check the date of the last post in a topic, to avoid replying to (very) old posts. In this case, it is over 1.5 years old, and the topic has been marked as Solved, which basically means nobody will look at your new post. In such cases, it's best to create a new topic.

That said, pie charts and donut charts manage their colours a bit different from the other chart types. You should check the Highcharts documentation to check which JSON you need to pass.

0
0
29 Jan 2018
Copy Link
UserImage.jpg
Andrean Hartawan

Hi 

How to change the legend color? So that can have the same color with the column chart

0
0
21 Mar 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Faisal,

We are all volunteers and fellow community members, and we answer questions when we have the knowledge and when we have time. Asking to "explain in detail fast" may be considered rude.

That said, your question is very likely already answered somewhere above. Check for example J's answer, or otherwise mine.

I'll close this topic now, if you have additonal questions please start a new topic.

0
0
23 Jul 2020
Copy Link
Post Closed