This topic is locked

I would like to have a solution with graphs

4/25/2018 9:47:57 AM
PHPRunner General questions
H
htmalbenur author

I would like to group by sex and by years in these graphs, and have the possibility so that each indicators can have a color.


Thx for your help

admin 4/25/2018

Take a look at this article:

https://xlinesoft.com/phprunner/docs/chartmodify.htm
It shows how you can change colors of individual series and bars.

H
htmalbenur author 4/26/2018

thank you Mr Administrator, but for the legends how can I arrange them.

admin 5/3/2018

Check this for inspiration:

https://docs.anychart.com/Common_Settings/Legend
And this code needs to be applied in ChartModify event:

https://xlinesoft.com/phprunner/docs/chartmodify.htm

H
htmalbenur author 5/9/2018

hello Administrator, I draw all the documents and information that you sent me but the problems still remain, I send you what I would like as an example to finish the other 20 graphs that I would like realize with phprunner.
sql code:
SELECT

Sexe,

COUNT(*) AS Total,

YEAR(fn_nord.Date de remplissage) AS Année

FROM fn_nord

WHERE (Sexe ='Masculin' OR Sexe ='Féminin')

GROUP BY Sexe, YEAR(fn_nord.Date de remplissage)

ORDER BY Année, Sexe


query design:


if I make mistakes I would like you to help me in that way. Thanks again to all of you.

admin 5/9/2018

What kind of problems we talking about? If you need to change appearance of series and legend you need to follow links and use suggested code in ChartModify event.