How to create average lines in a stacked/grouped graph using Proc Gchart

[ravib]

Hi,

I have created a Stacked/Grouped vertical bar charts using Proc GCHART Group & subgroup variables. Please refer screenshot attached with SAS Graphs and Code used. Please note that C= Credit & D=Debit for each customer/month.

On the same graph I want to add two horizontal lines showing the average credit amount & average debit amount across all periods specified. I couldn't do it through ANNO= option available. Is there anyway to achieve it through using Proc Gchart?

Appreciate your help.

[ballardw · Accepted solution]

If these are to be horizontal lines you could summarize the data to get the mean you are looking for and look at the REF option.

[ravib]

Hi,

Thanks for the solution and sorry for the late response due to work load.

My REF values need to be dynamically calculated from the input values. So I have created macro variables to calculate and call them in REF= option in Proc Gchart, which has worked well. Thanks once again.

Best Regards

RaviB