https://communities.sas.com/t5/SAS-Programming/add-benchmark-to-sgpanel/m-p/336361#M76240 <P>Please provide test data and maybe 2 graphs, one with the result obtained and one with a line drawn by hand showing what you want.</P> Mon, 27 Feb 2017 22:03:19 GMT ChrisNZ 2017-02-27T22:03:19Z https://communities.sas.com/t5/SAS-Programming/add-benchmark-to-sgpanel/m-p/336238#M76197 <P>I'm trying to add benchmark to a sgpanel chart. The chart is simple, it's just CTR, CTO and COR percentages and I would like to have it as horizontal bars. This is the code for the chart without benchmark:</P><PRE>proc sgpanel data=final(where=(user_name='xxx' and (event in('COR', 'CTR', 'CTO')))) noautolegend; panelby sys_code / sort=(DESCFORMAT) novarname colheaderpos=top; hbar event / response= percentage group=sys_code datalabel legendlabel = 'Percentage' fillattrs=(color = orange); run;</PRE><P>So nothing fancy. However, I thought about just adding another line with hbar event / response = benchmark... but SAS puts it on the top of my first data series. How do I control the placement of the second (benchmark) series?</P> Mon, 27 Feb 2017 15:38:39 GMT https://communities.sas.com/t5/SAS-Programming/add-benchmark-to-sgpanel/m-p/336238#M76197 fsdfs 2017-02-27T15:38:39Z https://communities.sas.com/t5/SAS-Programming/add-benchmark-to-sgpanel/m-p/336361#M76240 <P>Please provide test data and maybe 2 graphs, one with the result obtained and one with a line drawn by hand showing what you want.</P> Mon, 27 Feb 2017 22:03:19 GMT https://communities.sas.com/t5/SAS-Programming/add-benchmark-to-sgpanel/m-p/336361#M76240 ChrisNZ 2017-02-27T22:03:19Z