Hi, I have a dataset which I attach herewith (too many obs). I use the following three pieces of code to generate graphs and export them to Excel (I use msoffice2k since excelxp tagsets for some reason does not work for me) Unfortunately the results I am getting are "horrible".. I am getting: -- messy huge labels -- the dataset under the Graph etc.. When I am using the BY Dev_YR_MNTH; then I get 60 graphs while I would wish to have them all in one page side-by-side. I would very much appreciate if you could help me out to make more presentable the output. Thank you Nikos ******************** ( 1 ) *********************************; ods msoffice2k path="E:\Val_Results"(url=none) file="graph1.html" newfile=output style=normal; title1 "Amt Development by Age"; symbol1 interpol=join value=dot; proc gplot data= Test; plot Amt*Age=Dev_YR / hminor=0 autovref; /* by Dev_YR_MNTH;*/ run; title; footnote; ods msoffice2k close; ************************* ( 2 ) **********************************************; ods msoffice2k path="E:\Val_Results"(url=none) file="graph2.html" newfile=output style=normal; title1 "Amt Development by Age"; symbol1 interpol=join value=dot; proc gplot data= Test; plot Amt*Age=Dev_YR / hminor=0 autovref; by Dev_YR_MNTH; run; title; footnote; ods msoffice2k close; ********************** ( 3 ) ******************************; ods msoffice2k path="E:\Val_Results"(url=none) file="graph3.html" newfile=output style=normal; ods listing ; ods graphics / reset width=11in height=16in; proc sgpanel data=Test; /* procedure statement */ panelby Dev_YR / novarname spacing=10 rows=5 ; /* classification statement */ vline Age /response=Amt group=Dev_YR_MNTH; /* plot statement */ rowaxis offsetmin=0 offsetmax=.1 max=30; run; title; footnote; ods msoffice2k close; *****************************************************; A part of the data follows since I am not allowed to upload the whole thing The rest of it goes similarly 2010-AYMNTH-02 to 2010-AYMNTH-12 for Dev_Years 2010 to 2014 inclusive in total 3.600 Rows Dev_YR_MNTH Age Label Dev_YR Amt 2010-AYMNTH-01 Age_001 001 2010 2,850,099 2010-AYMNTH-01 Age_002 002 2010 11,117,981 2010-AYMNTH-01 Age_003 003 2010 34,867,950 2010-AYMNTH-01 Age_004 004 2010 23,447,194 2010-AYMNTH-01 Age_005 005 2010 24,293,656 2010-AYMNTH-01 Age_006 006 2010 32,975,181 2010-AYMNTH-01 Age_007 007 2010 26,220,039 2010-AYMNTH-01 Age_008 008 2010 26,635,979 2010-AYMNTH-01 Age_009 009 2010 31,923,086 2010-AYMNTH-01 Age_010 010 2010 26,892,443 2010-AYMNTH-01 Age_011 011 2010 27,122,684 2010-AYMNTH-01 Age_012 012 2010 30,580,320 2010-AYMNTH-01 Age_013 013 2010 28,245,592 2010-AYMNTH-01 Age_014 014 2010 28,541,518 2010-AYMNTH-01 Age_015 015 2010 30,710,224 2010-AYMNTH-01 Age_016 016 2010 29,069,422 2010-AYMNTH-01 Age_017 017 2010 29,359,624 2010-AYMNTH-01 Age_018 018 2010 30,458,658 2010-AYMNTH-01 Age_019 019 2010 29,542,177 2010-AYMNTH-01 Age_020 020 2010 29,618,125 2010-AYMNTH-01 Age_021 021 2010 30,443,552 2010-AYMNTH-01 Age_022 022 2010 29,660,592 2010-AYMNTH-01 Age_023 023 2010 30,039,276 2010-AYMNTH-01 Age_024 024 2010 30,581,351 2010-AYMNTH-01 Age_025 025 2010 29,989,269 2010-AYMNTH-01 Age_026 026 2010 30,095,406 2010-AYMNTH-01 Age_027 027 2010 30,694,898 2010-AYMNTH-01 Age_028 028 2010 30,182,014 2010-AYMNTH-01 Age_029 029 2010 30,212,399 2010-AYMNTH-01 Age_030 030 2010 30,525,439 2010-AYMNTH-01 Age_031 031 2010 30,195,822 2010-AYMNTH-01 Age_032 032 2010 30,192,999 2010-AYMNTH-01 Age_033 033 2010 30,499,030 2010-AYMNTH-01 Age_034 034 2010 30,411,645 2010-AYMNTH-01 Age_035 035 2010 30,399,975 2010-AYMNTH-01 Age_036 036 2010 30,504,148 2010-AYMNTH-01 Age_037 037 2010 30,384,613 2010-AYMNTH-01 Age_038 038 2010 30,346,111 2010-AYMNTH-01 Age_039 039 2010 30,441,818 2010-AYMNTH-01 Age_040 040 2010 30,309,287 2010-AYMNTH-01 Age_041 041 2010 30,319,272 2010-AYMNTH-01 Age_042 042 2010 30,422,982 2010-AYMNTH-01 Age_043 043 2010 30,316,635 2010-AYMNTH-01 Age_044 044 2010 30,311,218 2010-AYMNTH-01 Age_045 045 2010 30,418,184 2010-AYMNTH-01 Age_046 046 2010 30,268,734 2010-AYMNTH-01 Age_047 047 2010 30,253,868 2010-AYMNTH-01 Age_048 048 2010 30,424,075 2010-AYMNTH-01 Age_049 049 2010 30,326,897 2010-AYMNTH-01 Age_050 050 2010 30,378,397 2010-AYMNTH-01 Age_051 051 2010 30,472,322 2010-AYMNTH-01 Age_052 052 2010 30,366,263 2010-AYMNTH-01 Age_053 053 2010 30,366,263 2010-AYMNTH-01 Age_054 054 2010 30,471,581 2010-AYMNTH-01 Age_055 055 2010 30,523,409 2010-AYMNTH-01 Age_056 056 2010 30,522,997 2010-AYMNTH-01 Age_057 057 2010 30,529,264 2010-AYMNTH-01 Age_058 058 2010 30,559,098 2010-AYMNTH-01 Age_059 059 2010 30,559,098 2010-AYMNTH-01 Age_060 060 2010 30,573,054
... View more