Community voor gebruikers van SAS Visual Analytics en SAS Visual Statistics. Updates, tips en nieuwe functionaliteiten.

How to display % of total per column in a line graph?

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

How to display % of total per column in a line graph?

Hi everyone,

 

I am not very sure of this topic has been tackled already. But I will shoot anyway. Is there a way to calculated percentage per column and display it in a line graph? I know that this output is possible in a pie chart, bar chart & a table. I wanted to show the percentage over a period of time and that is why i think line graph is my best visual option.

 

I worked it out in excel to illustrate my target visual output but how in SAS VA?

 

Thanks!

 

Evelyn Casio

 

Knipsel.PNG


Accepted Solutions
Solution
‎10-25-2017 03:22 AM
SAS Super FREQ
Posts: 774

Re: How to display % of total per column in a line graph?

Posted in reply to evelyncasio

Hi Evelyn

 

You need to do some calculations to display it like this, but it is possible. You can do it like it is described here:

https://communities.sas.com/t5/SAS-Visual-Analytics/100-Stacked-Bar-Charts/m-p/153322#M595

 

 

Check the post from @EO13

 

Your graph looks then like this

Capture.PNG

 

Bruno

View solution in original post


All Replies
Solution
‎10-25-2017 03:22 AM
SAS Super FREQ
Posts: 774

Re: How to display % of total per column in a line graph?

Posted in reply to evelyncasio

Hi Evelyn

 

You need to do some calculations to display it like this, but it is possible. You can do it like it is described here:

https://communities.sas.com/t5/SAS-Visual-Analytics/100-Stacked-Bar-Charts/m-p/153322#M595

 

 

Check the post from @EO13

 

Your graph looks then like this

Capture.PNG

 

Bruno

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 600 views
  • 1 like
  • 2 in conversation