Page 1 of 1

chart with panel data

Posted: Wed Mar 11, 2015 6:19 am
by lana
hello
I want to make a graph (see attached file) where I want to express for just one year (2006 for exemple) how many companies (index_number as cross section) have an NSFR (ratio) up to 100% and how many of them had less than 100%

Re: chart with panel data

Posted: Wed Mar 11, 2015 6:22 am
by lana
sorry I forgot the file :oops:

Re: chart with panel data

Posted: Wed Mar 11, 2015 8:35 am
by EViews Gareth
What do you imagine the graph to be? How many companies meet that criteria in one year is a single number. You want a graph of a single number?

Re: chart with panel data

Posted: Wed Mar 11, 2015 9:07 am
by lana
sorry maybe I've worked so much for today that's why I can't explain clearly what do I want to do.

please can you check the attached file.
for 2011 for exemple I want to know the number or the % of banks that meet the ratio
thank you

Re: chart with panel data

Posted: Wed Mar 11, 2015 10:03 am
by EViews Gareth
ok, so I'll presume you want a bar chart. How many bars will there be?

Re: chart with panel data

Posted: Wed Mar 11, 2015 10:27 am
by lana
I want to get the same bar chart and a circle chart too
for the circle chart I want to have 3 parts : for those with a ratio less than 80%
for those with a ratio less than 100%
for those with a ratio less than 80% and up to 100%