Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
After a lot of trial and error I came up with the solution presented in
the attachment for reformatting a chart such that the inside dimensions are exactly the ones you defined, e.g. a square of 70 x 70 mm. For the cases I needed (only XY-scatter) it worked fine but do not be surprised if miraculous things happen when you try it on your own charts; a lot of surprising phenomena, or hidden intelligence if you like, in the chart world. Thank you for the suggestions in this news group. Janwillem P.S. I am from the ALGOL-60 days and have ever since made an effort of not using BASIC. I would therefore not be surprised when some of you can improve considerably on the coding. The xls file is compressed with the Open Source 7-Zip http://www.7-zip.org/ 7z'\08n\0\0\0\0\0\0b\0\0\0\0\0\0\0?!\0h3 0w`*@v'܈k' *BЉIMt*QY쾙[|6]i߯NjIO*BHG[el;#MpO9^P"*;֎ _vSؑvP"y\ϝIp^*Y$F~$DMlWaxJ.s< a%OTZiLaNMK'Ǘ:WL*U%orjj&az_#|MfsP |e}O$lgP)_1BkiV_PV/Ry(F/凋9~ˍm$UikJYV{b2:4hLaa{-U]i ?{ױ䒂1oFx eX#T?f<*9x[{S\0IɅPr@h8@QEȧ4(;S1 yp7LMZȻsR{$'P*q *U˳1+w2(y-i J5D}@x@_W?ٸen#_(y 3iq|\-6t6j㱟kqۈh%aV*$OPEr,z 'UdGתbwO|?enE-Rm|dC{^#*Ffzg1Z5*ѐ{[ET:*Ỗ׃$+< __'HudWP4wޓXkt3-e~MS`ɦoW*K;l1\0X: 4Rsfqr;oc /Ez0|zjBO\4usnb\3 XI8{SOǚ*#e*sgq{K*Y1iqSil E`UǘJXZwx)paT҅X(wY5 $25ucEg:$7`s] Aɦ} `FyD@`r-` JPF{D3$Wq1hJd!M U`NrlL6H[9]&-lhp)M'T~i^%z}-o_x=яx9d</~(|cn+8W9wYz^ԇh==W$R*58[z˒w ^{&Tm W 5'C%s@8T?G`j?W5IۙE5TbU( 8Muۈ{=l2^Զ) v5h*Ț/rŪCEjYrn;?aFzF|f*{_T<@L4Y܌\ 0r'Ӑ*~儕[7wȇ!ֻqp7: gU'q" mj:uۃ7hL=1K$QQ7ʙo+lף |&BB}VmK=90̚4߂I J*|nz2VKow_|X&5Fai'_v\rR#s. CIVֿdH ƣj㯯'HNr(.W!g2?.4U!ܾ+Mw Vs.W*XNOs:k0Kk=r5D.\0b/0:;t#L\ c:W/Ӕ|+6I5OWAF&#A< 6FDlDZ#C?pT,2c' NsCYjQuibaݷ0iљEmhv \Q@UOXqq)nwYhmw]oĜ恮g:E|D\KK5IA@pGP* kHѢ?()B7#vH92(o r*}bTō{\0EnSx//BC{/V$raB,[*/)EEwk bKq٥!ujs=&dғleI|kGw۔ N΄)_`4jSNk\0$" ;ʆ\Oe,"ߕ<nadƉ]$.yX-915hqߧT&+&cH0nĉzR9Q; y-WN_sԦ~Qzvuflv$we-˕<D]{y?;gc{?^j*pLf(c{yJ*r~W/yW"-{3+Ξ ^<Ybi94&Q 9tsCLITav͐V(SAУMpo2f\ eq[R8~?*ia)\0Y Q.BC<ʽ* f;IwēgzjQf{F"hzx* &|R~%\0~jZZjjE拤X 3E{e*,4YYga=O7~s gv5qeԉ< u@&k*C Ќ|~Cj`oq]ʉ`1Fgu|^c?<`LEā-ߐSkS˟1Ǫ7?)yP"$'+C~fO1('$Em 2LQo7*c\07X e*S mQMhm2[[n-OiH*sNG^w.z*otT&!/cjapjqHopeV/d@jzFSgCN4R%/n/kaFAa|&)X]+H4UՆ"9iux9zW{Tuy/G:=nH!c3r`b6g-xd=,Q**O[=ĽuG)QȨ*̸K#d1!P_E 2Jyʾ}BX}aw+B/sp*u&u:=S8ulaLb&w XJ@vLx\9i}q<;db%ۧ^Lͫ _NYzD/ܢ\*ep}<d12MD8=4*y6E3 _I cgtq}QPY1'LMjJTքs/PbЈ9Ǫg\0t5P0Z1.* Nc/:VW #vgm8.^UDg8yNtlXsfM'w p$B סjRdq~-gN w@"]N\61mRk={S͘DO SU$!뿙IqڴDC(<; C]?=;G77A㫟 `CXŻS*A XӾ# 7C|jtEZꄞU,\0?DW+*)no~|~7:| C?%`5AV(\SiîTq<6i4zWOR Ͱsڞ' $D-_V`#g&6B8!m$w@C}0pKtZ\9B* cwCi/ҩ^mʛ|C,姙w-BLCߧ`ߙ*}PГ*眸W,EcƧnxIM]7!&^%(IϹ**6V6}8 d)kō GjcW%t|u<*6l}\CpgZWxi;큆 Q F*0\-,=[]|0L×&]8_n&ZwϔWkÆ_ |HEg]!c8)(KGKW<$<n*F9*דRmўyu22!Tyl]JD[;u6/d]2q#]m}S/* Oc$2g~Il.9̉pu-/T9m?Ljۦ,F(-\Jj،ܾl7 {vT^$ }ݘm*f]j"d|,&n}B4mjJj%Йć7,1\zC |{5!4AfI[~;A"|]rAs^*uXʳdI݅bAX/*ixvPVЧ` ξb<. "}-b%"}5I9sb/Zk/D渇D,-ۨ@J!:aȬV1'}v ]dԃћ[8t@Kr5*rG$'x%56J.=# .(%" pUhw9R͝ED!#"U1:p:w4l\0 $D hjO-6HOy0&ZH/R=@ȶkU d!&Xo*Uun徸yc,*3wu-"+oqx/&(DY`:Vvv m䨖S32YCtpgcKە-_AW4_[.Ϩy5J**'J [C,^SY_oeS*`٢Zng? =*IEE RzYGU}݄E1tH0QMaGKN\0 Pu]!|<ê00yLun_Nee sTMۓƷ|!VozhML ô|@ *K<v?8*D'gf3i&ؔm9'xiA 3*礌_l}-yvj%9}`xs ,Zڒ_+R\"@Lpŕ_a,[1#\0?W9pc)YۉKzJ_mWfG8 AC#mPgq_[pڛ(tDe**<ѩp27 y|@ÅddêO /xn,IADž-wW&Y5Th_A'X*^'K}6-ѹM?/Zzᑧtt4Y]6*UTOjaϤC,\0 }mA7pL!_EJҔ|(G)fnZxgU/a2F:Hl,bFx\-p?+<˜ "Skthw1:!Uym=|'d^,+O f^.!D}8q0Ph/ilLCjpfۋa;1 ZjdfotP(Ȁ#LTnfRz5* 6Yx0TFHxC0ӧUr'G IVx3_'Y* ؟lY ("tsNF"nHo?/^X%:y*?g_T*Na-M*م<J`ˢQY9`̚'zdEǴ3BFf*?7U,`l"4n`\059 3#.|3nSTP=rPkIc! p&uvk&9*#+Q\0 ܹH/i ӟO!]xe:**;LWWpd2x˻ڛky҃OǓ[Db(CDl*WC@lONpij-Fx=?~`RUy}*-|qDD\op^.\0{Ӫ8TX܃_!\0,d-$w&^ۦu㜶`kQiw%F!s}KF ̓I\0NsQaMZ%S)xz<Ƨ-T8<B6EG\0"c;iq @@g,Z``]uH)f/yIU*bѣAB"{o :a+E['9nd-06(Z\0˷Qh)vN\-'TWP܆S7R-"]*5!J*nhwqb ,xڒM[9PJ\lj622g}wWXAxWZd*0]1&}IBLcxա]Ҋ^AobnAˣarQ<cK1nl$fi jl%{NIMy)M9K93TPLݘ9% rW݊C[:33:McQuǪLnYýOx쮙Cһtdڢ!Q}Z(*ODh ߝ;l*.W /tēm'\0g\Y*3Q\}K9w@iӅ[X+MVF"Ny@bl/ʬaĩ%dm'rzIJҹ}C|M*X,E֚ο? PNh\/f#Guda^-t*g!NVac}sܒ "O~(FBsLPqz*H:?(F*4MX++ 0 zV=xZzQn!Eqs\07!u!aםm \0u3t4 __E;j=bZETFUyB̊cEVIzS%XQ*% 7 p~V$EʢLy\0s*8[O<Ɯ3KftOz[{gzPc:l{dL*O}\XurQh ܗ]G[?i)K^VH*\})59I?Ñ%:ל-,ٖ݊VkUnON0qzA++5Eu_NDػQc @PDNt-E\0k043Mc~:$gÝz.DZ[N*%K8G8z*wP7IRX5"ם%( Q9PػR('FZo*rTm͛KOrMaV H;b#"qD\0i?\03]i9nTU93QJ';b=}-@s0V*`'xWPuA,brcT 3/4^j9z2vxms`W{wEo Q"fy*3u,|XMQJ X}16*|\QND,O.&1~2{"'y(Lp @Jb-ddw<dA!L\{lOă/<9~HS'iܤl 0N{ֹ+9Rυi$Ԃ1KnF !Y^iѐ(Hq ;1@7%P<w?_JV#\iwE4~<P m4$y #\0ml<0*Nm!9#+ .&ci;(t.Z@1f4䷞\0f_ -|n} ko_bsTY}an1C\m x*,ͥ۲-%*`ʀoecqeZ-1!숡?צ-j-\~_ކy.W0<P.x)w)bq~&̹2 țwB\ *4O;|f*m\0m[n2wlFkU*24$p) \Si&źң֤*(7N1G՟F-X*WTkNq) |_2IgĝX?yg0V6D%v#(5qx{ .c\p`u#c&јm=CL!3KBZ ƩcBA/.)`Ya{dt,uI*K]RZn*0f1݉_H'G#c0MAz5*3 j/5܄]y:Ag_jl*ym cQk&s,1(T0ͩ9N[#OM?Te]/}xwQ*oe$ٷҡ(E Q\vtlN*2gD!*&x,;K*Hp{ }T.)V}r$ - !DB̀EJzx=kOהRl/!ٗШqBL֡ZBWƬbg`~eS<9y*J%` t 9lD,ǔ\.YjDIRĄ؎9R@/UI(Kx5Odkxr/ =XjDm˽}s 8H@U)PQeHKG:5o*CXU_^^*β *Gϕ6C[%N8W#PvUWۻzW43g$:)Ҭ.zhʣ QIW(jdF-N74܍9d_F<(JS9v LYu{<q+$B )A\0pM71A'P,.0QB-jvF_te\0 Pwc<|Z,}6n.ڹAu,^O^8wcTq Uu1 E1D(+Z./#jњ.5FˡSg*eO#gRE8NJ\(/e'Z;UD9ޘ%= \0}J/Z2{/ϥFS&9P*-r6HFvf(6OU_9&v"vP K\ѰGc8Q~Աl*^1*5M*XWE a~(q$r1qqRYgcTj5Dڱ},Cqz6jf 3&H=:m7wa.ʢ"'XJd XV4I=fjN wX/.h_A\0ٙv5'2#ǙwTыݻ9#9h: .jWxK$178Ҍ\rC@WR0P~!+*1u$ -+}U*aA#x{&#TTP٦_Bh0` J9E\06;A%'Tdzg^<J*@x h(1Sa*Y\0(Q IXos*,KӁi'g!j ¢[\0Tj~u1,.)tN&Q=5!ӲlD)+kGW</am(gfdDJ¦@1E.:C5*-6t*^ ap\0< {.\0YxEVJ|<4,k'wDM=%eR t;:fAU!!N ]asenbkDWEȰEa}]{7 {Pn~\0J8sFpk0]3= \0ºWslpp$;b)c6zh[}Es ImiSMTmP*[6E!}v)dhQ%yB(!-&K*69wtxIGo#ѿUHsyҳ /}H1װS~B~tR`d"t9AF<)t O\f@)\aτcyg{`(6[1@BҲˡ0ߐY8"'ڒOɃ*pqJpO`2UN=v2H!WŇ\05ajز6 V *?/^:x*3r_uP 3]X)ToSBI`L})X$*8ր=taO0~; x?NN/dZąA\0Q@T?ԧeЄtC/N}wJpҜ'_.(w Y{Q(T!VI3`A},@BGv= )X 9+4lle.ȾfJXiaBk[,w-W*KcC20]YFS3K AwLY'`R5r,w`2*zI`P9X1 Ln*]=o$UM9Fm,xyt\0&̨xtd0 "]'|#48y*]u-s܂^(y 8/؈˯4!5,7#*:#ϵ*4 cUcqL?/^+_z|\0*~0)?)(Ϗ^+[`,=\8mb_r*Y0oc.Nt]դ=O4^ƽcP҂s$Rn5wҧ5Rc 3$kA3zO8hxZdں2mx]e}eܪ)]P\0gaq;Tޱzy|j^gOSI{3\0'Bߞr KXeIX.}BE0YV˗("K?-$!Bê;2KvaCa\p(c p q P#E2zJVM5r&L¡o?H&s;?d5zkWSzR=x~ uN|OƚmA^6967+ODͩoT@ 4uubjFM8\0^RA=:/Ltz|s)~O/1Тs[0yn*S-\0MfH(t/7sWt0Oj8,*ݜ`07#*zAfgHd%y d:.\bWKA^1bVa@M`kTߒ͉L E؟Bg$*q4QZz/, nLh%)VXak/xB!s9Xa<Zsރu-*ZhAӌU4Owm ; CAC{MjP@5ke*2D){˦A8 _DD*r`8tJRݐ*RE1εKJ~Odc *.r'{,JdڛeYq!?πUӇ^Ixg \a#5cC`_k5^*5Tf$Q9҆k#~w 6zQ \ӿ& dwFO8rF(b)}^#K++15? ZsG=tbn;J(-j}*;i(xقHi}Xb5*u觏xu B#C A.G~`5[Z$-lc~%!Նlicp8΄-іCu춊ERl-Ȟ*AH^T{Z=hv1*f^*;B5Z%c_z` J<<j3*u ~Gʰ601 -ӂ$Suɳ#f3"w7`y*ca٨$@IO s`+Ч0KgX4a;$2rmRvp*ZN| 7ڽ: Hnggʦ@Vc'lh@uAgCW-]{7uTtco!՚9^S~NT;e,lʘ$sS vjoyiTS\00{A +,Zn9ǽ^4e@jj[KQ,i- ,OC2#A_ѷ=Qu)BĊ_-Z:jp~;?? g٢A8ȸz2o ڜZ%lÊM&~pg$8.,wW`,*Œ`\0 혡FLګ?v:T`9#kd7k*ld vjBsdr1(2Hx%3zLb= $@uYH|\0= UnKz@\0bN ;A e"THoThd$F'<ġYeR{`l4'$Y 6tw1Ui9Oz8*xgˁ&A`*B f\0}e!碘n 8o~Pr9)'a,0+Дڰ<\0aGiS4rA# k 0)ry \0|1|F;Vě Ύe5+iy|Wɝo~1BBFP~ #e&k:5#{J<VhJ= sҼ@$W0uQ:uť1*Ev xBu}̾V F6^(@4+ aA$'vxާ[vrDYoi$aAMթej0%+5GU:"EZ]Fxi*w18K\06i&f}PhUMl?\0# .&z*nL#nU_^ؑ%Gb/fEKOEbl?b@)#~ OHG9C<;Ws{ΖѰ/nkB?~%*Z}QXB xU/`n*Q^U8c _l.}\0Τ*5baN3GlbvNM L81kh/PP#DS:{NEs03ObW`qQ/H`'k,:kMvbm@.[hӥ_ѲwW!\!+A)K㑊& &ˋ&-2Q~\]Zvlkjv~lVϖ|_6d{ddQ<p L6lץ1 `)z]l)hcį[QOd/?+2y "-|*$c$Kѽ+u933̐=rNu Pӎoч=wdy S;u 6&.(T,E馥s({LkC<~J) )0*bk2C,:.Un#ɳ5\\tȴAwǍ 7\xUлe7*$u&!_c}{2R/UB]2@n$*Ќ}`͆2Ȏs3bC)xGyGU@ P*\*hMc^]_}a5]<R=\0n#3X9b]p(BcBP`u<b&[\t{2*Jdehl:qƧ*~r s@W@0.pڗ/2w|H6*t=NR:01RY[y~ApD "ڝ1l]\0=9Qfݖ`*p6/emީ|tc?/'Vc7\0S&xj$K_;o~ VTHhO8`Ǐj܌\<֢$pG0Xw/Oy,:3QF y=Osen*4Ax|A<"Q#æƶ% q`7B=yt%âW۬Ō*KkUt*`e _:8VҒ7|u Kfg5xc 2Q#;*n/7?\Ӓ?;|Bo/~P Md'v$E} \:g`C9~P?8Tш!aYKȉ+M~hw& Ev.ޤtN / .AKA|TƟ<8B~40$d =(V===őBEQfطaټZ%~<x< 2Vo*C Eq l\0=tc3yQ8:ϡ]tq6[=d-faMe s咳RطXӒ}TPUE8hCFCu74k;X ++`)\0e^&ISf\%N?qc~,c *:L*nhóHifOM0`a(@TB\0Ly5 :7c9Ƈj@],"UMѰt͆BoN"5g 棹̎;"dH 肢g 5~jpEݹip2._J藰-C<]jҞN<cVj{ le=ώRFIq8x.y#?vEI hbF@qؕױ]߃136 #.%<TSqTc77b ʨ ĄL(c\: |Ĩ=ƅ\0@mAkCuiM]ϱC{kd"! I̽b,EY?,4֑K_(kۤ&c4 E;AYuhV0pGٚwڛnCDuA BE1͵WXVy߃ lTGpczC=`T nKqJv]'iHR:""v9#ʤ`u^+q x Q9$!*K8`&h-d!j{];?w ~["PcPdχT [vWI PǪ8~C8Q}-+Ae`zǚ2UTxDz;x2Γ訅 O [i?q};%6̶;kE5 AAg g9YSV*PHa,I=v6ܻlCs6f* *P89Ċy;g"!f/cIx99vgZśY})y5*@rC7Xy?[fUH:JF:jkHCQJ:J *Z}dfĞ;R)g|`a~_Xpz6e ZC50r"zP15-*=ڪq$LԨFSomB^2!b5* Vw;DS |Jg蚶h8m2l*"f&ӸLZov/+}Ծd8"X&D~0)EϩɆ)A-AJn&/3MTtZşiՏ~%=@ bC*IQ-?Es S`E(u<f\08f.,;Ivڂ+Bq=Q{9&ho X~8hs7O?RImkG8?zD+o My\0 }ȶc 1* (*,'GN?F1&,f{|?H;hsVɈ =%n_"XS*N] $`9-6'Ԝ١ K~]#m' nªG)hU I\0u#e|iX._5h(!asF_* *XGw2R*sډPqsW\0ˎU.rQE_ **mRoJhRyx-H4]Q3L&%\0NNLGHTwH=3SK,]/MWL_-ZE0Zc,\Ik)!! \<T.;a0R]{3\0@XմS$E]@DiL5%*0mݳ-N9A58u)捝:.@M "*ɶb})nHTr<_Ĉl GWK1*9={m5n#cNώFUZg*S_I,Id=BN\0O6^ Ҋ{mG!&<4FC]*# 1'Gsx!it/(T6܆r;YG)0'd"W~較hϤ'yr=/$7߶,Ѳ0ܩtrTxz Xj|\ 9a }pڬ\0e|*A'.TйŮ'+/?W{yY*-ُI)gM H}*:V%\S}@ŹakiWIL6t\ 5mGmdfETrzΏa^aC#JLT2 DZQ&HDۚo6vZLDhg"Le5 Ȍ8 ;˿/3H(EgbC9eiӕئDALf̒#Icl fkUJܺxg6iȪ ~EGU0bG)V=\0wtsfRIk ] Nmqʻ6=`3=W ;MU5\5f}U&ZH&|p[#E*}Xu'hhxa$~5/ DL$Oc/q"qm_~f5.%)i`iBqROa+N]d~\;;\0OJWPo~ʯ*TVI#: \0 |V~?c&16xQ0[B:EZ%eG);<(;*Ɣn&;v?9S`n7 Um)I7@|$ME!/{^hIP`#*&\}G8r*fXsTGF WwSt3!j*vm[\wE *g܅#=;X!n`` ,A6#¬@/$E8/V;]=I 8H#;Ehq(}'lD}=<G\0$!hjL7mJ)Z_5vZ Ud Ab+o AJ)1ҝg/ۨfS*3(lSX%. e;<Wǩ'.Yvd`lޛoPLi*)珉 M Ehb;c}:(VȈdzҡ 97!3TQ}~ ǂ\0YMYµiťW]6X۱϶.ċgW|O`ܐÒ^` ;*L0&*ЏjBGg)&YK*;WzDG pθ!+#9yo^;Sp*qX3^yƄ &eUU;ɒ)\0rݮr{/|Kl@$W9%Ro2m5dt kUh`ܒ7E \0z9mW6`C5KgKDA J}}7Ds<ߟ;/hzzI&MX??@<^Iҧa6OP 0N\\ny@TKT*!披noI u(r|x78خx\0|9^ܵx *MLi/m+]YG];#fU<}*M3pdʋ11˫4:'h kqK%9M-ek995xDoMXI7Ʊ5d@)^J ]yO|E-ڇ߳f1Ⱥ,OZYd*0K m\A\0b O8GiU)\0E;6E3HB.ks\0 u hTͩ=:q^c]X"`e"@H%Mf%^PDU*I+?٦l9G3\ fiGu:YAMN.˟Pެ0Q 6}"OG2b9 iv_ܣy+AXCs\0{kS?+<dS"H q=wQĄuÍYa|h5*`"\{3c:^W~ ;AS(fgj/s|+@Z\0B6ERIJtUsةDJ34:_ *X۴]eI,k,W/=wXȢl'\;n(V;MXh_atS60uw0*o-e5WT"!犺<)&%;KvܥFA23(E 0% e*OenmoKCHo6*8IАYiZο㣡 o:kC@(F{v37Q[saulmaǡM~3Mtn-WUy2<$}1H?QEw[=x3(2Vݤ$\<Zrq ;աfD}G̰/Nc`*OÎ!# dGW<-E|vtK1њï:DO*:1=56Iι A\*߿]+w.&)`Vq-h:dh[5ȕM[o=Of8!I*;\pK@\0J^l%HUޏMAFy6 qouFJQQ-+_$^!-k\0t!r}6@0i)^V`7 vH+g-YΑ;A(e\p1ަ9*i^8 S*vͺ}ƪjNĦ*/{k7<эG^;/0Q%/$*TMS%;.oI(褧zvv9FBc &7^!i\&M䜅0*1/V *MpY{K]s uq3q$,lEꞑZ1x}9pA0M~;?' x,GټY:Rb8զBq:86+S; m !. gweD7շ<6izJdRQ^\ c%LZ^[*^ԯ[&/э\08}ײE@Bww*ЃKzDЏa@}(1`e0i un%x[T.8CRo.ZzcOp dI70yr?0m~cp`Wrp|scő npƸHizhA? uvnjoQn^%bʚ<II7Gdn';+W[:`#28S8.ZNSلd) .s&ZV1&lVɥD4IΒH{; 7·9,Ɵ\0P-K=YAsNMw$¼Vw#Wëki-YxA1l4]EuAzn/VoaP<<IJ\0_MR1sj~y@ VZkܖawp7H%y* b36&qsguRPɦ?`Cb TSr4N#+t}l^/9Nta\5N3`gGo7pSDE*0F6qi"߀.< $祲Psc\ t]OVPXX;Ŝܬko*v@=m}I~f85cOT 2" 5\0gqpP;s&[ǤĔDAH !KIjJ_Æ%*\W[*:wѼ _qIMAO{=4ƘOB0{qDdpX ŗͫ'".EJtEwIiJ 'd*5%B^$I(U?6 )9~հۀ}l i([bAE37<icTXɛ_[п1x"E9^:ȗXL7a(01J`}n*:8' Y#o9&p8.U#cԌd`t:\Pהuvi3)wX*eގ]bCLN"THDL~cvqe!{WZ`* ̝~z{n8v,嵂OY6Fval֩|" !r``C7P2y#^M9FaZl:ϙP OE%*bR'u{uJ,i`AL0 u\ݦGyqqR2Zۃ2jߒAC*,uWr,@ T#q Ka5³Vf7ik@띅W"|twLZCTm,^6pYv5Q4ٌqᮽ{Kt?{}eZBZ/LnZXK\P꼦W1] <ΘI2a!ݕb7w~X6nDt <%)xYymm6j,Q vܵ+s/HӧdX)D.X*UHK~<.\wK*G8;S S2cRh:=?FEpxce=6S9Mc 7bT+o&f3~N'<,B96pw9 4Nx`8Sb66/ )]EUC3%oΗc0} 2&xŖV{*b`@_N'yE*k9Z]b:JYzUad}R+uO؝df= ƆIPӧ3(# -Vؽpٿ*6/?H9 pg3<;[گL~͑ ƢIWD]TcUwY.^ l, <Nজ*G/%I07(ofi|&#<R*Umpm{ |Wa#Y{2[- |FRNj5ƄY\0zdXH˩Y1*,t.zDZOs)TNLz+n K~d?nN'RfwDBAaՊg cN1;KqM)]D*1b ꉸhED(xu|8/QVŪT,XBiEq3`q6(J\0~6^: &PaG%!p6+$a^0u`[tOYuF-1öC"XAD/eYi9Q@n`N6^h}&d`4hP ,nT<o%(bYB&c{]w'K]v#;V;4ܨ&04Yar2~^4Ie'5jv_n{$\ h:3 9l5X.t=pd7ӀU!uoYҗV,"zF+ VxXGu_7ؐ&`)|`N1ϐ,5jÚ*O Dkh\0M}|kHzf@<sKRTLMvPf`= 3A{sJ(@#H"Zj-Qէm*yss2}b*YDm7KS))_ a:]b 3o\0&YD/*Ezq =!f#?ȯͺoqnMQԳ%7;M +5]ٰ/o=5Q*)m<r6(Ug`8h: .|V<eRNi!\r,!FixxTXAmqF` ;^ʍz53ȞhCVSܾ]S<=2O/9 C'䕊Jʁ4 XL5~d-܋bJ')]mr?q;N]Q=ҽTب!/:ZLJT떲GlVepO$y'YoĨGDfRMB8PJݑ6dkwQ{̝GҴĤ ATJٯFd*:Q\Qu^y66|qJb|#oV!$JfORIP_ԯmH0#-H.%W|;J 9<P1`hbHbc*Vξl?7gk년boP\0#Ф Vv2m3)j{1uP9^lS\0! qGCJmydM(hҤ-zYAB,ySfam*NHz6[^UTHt5]A$za3gg% ACp\Û=9@i`HRGݴo3: A1绚YZLX~!O~]hCiWa 'MIMTSer_s}|$@O܆0v\Iܵ{gv3 ǚ9lj#uH| 7vy(ۀBъ5*Wڞ]i/ib)$FXX*R52`t4oxj S-nh$L|PZ=}3rBx[B!溝{1eGRM@^[L)V-;O*Gݛl}"ɩ)eWza bRZ Aa,u Fȩٗbg UĶ(%KrdϪ(*U\IrLh`]3V^ΧdĄUFak:8G\zU-?;y*UvJ V/cPodFfMAL'$B U[ Ǖ:=l bR*h//^Z?RPv:Tԉ\(,CtJ*]dx50)j99łjb]`) R -hmgB25u:٩Q4'3[`)j'lc~Vl0o:R+p@CX,ٺd Al43Xf:Y3v7<p=)N|W`|ҝd,y`BhG{ "qu8cB<ffV&GC=jFyR y%0C!^yݽ|)ɳNPZ5GJ.UeA [salS+ԃ5%=WBJ[orK}<UojFDFn85LNQq%|.X` f1:@<f64={X@L,I{دkm/|Ӵv?.*Y k?9\0}s:ƂsN3':M*@qR AF/Ox-g<9FX܂Zu1.]qO}ܙAu27݉qJkX{[C(OB 1"8CcSGJ]Zin`[[f*eAeMR˷_4(D!mrn+AЩdTm p 0/*w{bqӕЎC2\P[d=&-GEwUhY*&tb x 1y[ M˹hG5 ݾ$y2ƃmt#86beߥ*+<s} Cdb뙘i(Vu}f"[ۯZܥLGR]5]Q6;\չc͍kKb<_Il\0*njBr (pp,;c 53xf){0yՂ(?@ TºOd*Iܱ;t~98@{cWa*|O\$z ~LO*l516T]2S1wvk]s@|3&N?~B`2ڇd #rF*bCծN%)~&;#k:' aeBi"G쎳7~6y߈]!mI/~{=\0Xۘݍi"lKZoc"<:}(eDM ƶۃTR6uEDܼ=,R=^1a١ә-?]r-Ң5NM}6uVlo(vxjvϙPjUA o:]*|j䅐i~亵(#lhemeA*ttUQ٦\0ȳ `HX_ǡ*U)u' [e*Y*tIu|FCsb+&V8\0* DKCPduk,g30tOYORknV $|FtYb3٣iH^7 6s*;Ъ q5*F*W#[ FtE(Å,9t dj@ȑ꿻S3ejChWZ8lAxT' O@IЁ-r4t%//[\0,D*o-mMKG0h%u m~uNB:ZI#4R8 #m t)P<b LۿFZ:&@^rt_LboXX]'a09##}O8\06ʱd<i')i~*4 a#)b'!ч*z*sWi9*thp?7n }tpZiw{`h7D·lEA'-0kJ-sغ}Qa|Sww5Tp"좓-ZЁ<%9l\y L*Uʐ.ކ*x4O}g(b$B nsvP\0|5)C I<1<*Ѧ,6i?Cr[@E{u 貔*4D4{ƾ ՜|lr*{**\BP;eC(߈MTLD7 l~C܋"3w͛Xڜfm#M$ 0$Q薔-*2&]?5@*Yz;z;G_=wU%~+'M 1)J.ۋ9i^%ᖤ*Ώ;{WOfg/kz m%XX6=,fz+ Փ7;a7$,L~"Fe.\01iW$ x gurD%96rFSh'kAԖ:nwI.Aq YuWఆ@SUp(Ws3d@P-4 DAOrD*x(*I.rɢŶHqgESq_3 my_/oXx\O#k4wZ}kl.(KFylb倶:"B6 ?!J/`,9d@`"U'8z;KG}#ytrR(8Ȉmb0K~ƶg .DIza?Ľp0GV5cRCΚ GBԍ\?,\0 vD8F ~x"J*i+YdHhZៜ|ҔzHb#*ik굫Wq<!)y¾!;@FkKއ} It\0C$;U+r@z;_r{3~uܦFn 3G*IkXӷy_֞p*DMޒ%èM<; cu.) ~l.@-h m*eY<\ל_^3G\0/7n:G}n 9Pt/W<KJeu$%VK]99K諡Φ_ # ^,Z8 TSfTod|گ՞dLhX᱑/hF ;WZі,I$f:[h 0ތEv#c7x*K(.|3` kPx~*Q(Ժ&:Op@\0-Hl4dNfOt8x=;l. H*^lWs* !*iEwHuZ៷vm\YK# A.C\^v9DO`ύzVN=UώHJX*YD=I a4ho~Q GX Ѯ_$ j$a6V|: ~0;eo\0ތ,Bb;sԟJ8 qExu`ZjDKg, 0i:_;4@ϯzԜl ̏Ni8ѷ?6]L-Ы7KF0<si'c6EV¯ݎSȏHhFѧqA F0h^JoRx}m\Y NhN:g;S.6<ϻ*}Ƹ63^ ?WA@*X` w*Ï*zh<mQeQ&I'r:^?3xL/H\$wrdyrgCԶ?1Mt.*u omȐlqCLBwrmOiA ;'OgxC4/;0R9XL,-Wu6B"xp*ƕO/L\00T"}DvM*e#'WiM~Gct .#J}sqPk痑0ʣ.*lˌ7s ŗ R(L);;M!,^lUs\XVzGai QudVc^zxI=)8uPXB}*< 쿏ps+#薚X]WkŬn\k9 ܴʴURc^M`zjeE n@nB NTpߍNeɉ<ʱjԣNR\0MUVRݚ*0 ŋY+i*PZ*f#e Qؑi^:|R\0&{ f'*S;=Xskb7۶Ռ0**Rk)cj_k\0 )NspT.*B}D+2C4ҪjϔFFm N#]4[c)_aBr5ݾ0$qQ$5`Mc*=DrW wd|Ps}$Yu"Eޖl5l9*ԙ õL'YR 2x 5i*\0} K&{6g]JHHKmQnI#Q'؈*.eV&(*'' d/-t?+eOh*ST3(@ ڱ.8, ,ia35zg 2`;UL%'rxnoJg0qI_ٶ !HW)jJ\^ջg(l\0*y{W@)!͓*| "6btz}ѐJibʤzL˾l||hS+³?Ӝi *8B',3~E&/.n$HUenॏ` GWuT'敪yc8䣩u 6yx8bflA+Ex*uہue)*GI 3F8|HoٞLCg% 89c a=LBcYĦU&s{(SiK?CX=:wY irsxa,r.Cx^cR܋%Z?A"I\0\ lc\0*dmLJm@JP,T^/&NWh d#QyST.Q?2z锌U]\Q-P-ޗ}N5ꓩm4ky/!_ڤNx)[Jļdd}Qib8 ,ܾUJ/Q'h`)hjT_1b){[0=E8cՁt-lzCb6<pv l<#,ڥRRݛߕ#Ÿ U؎T+\sYS՞yҟŦi;2F[BhSoB{W]9qPE]#RRZ?s<}(AM/A#'q.tp8w83+HTo[A#ZS!#Eb}2֫%$lL^~6^3B {{+/'*JWsER;WUV\0zG&<(aM]384Aƪ݈E ~ɧdPa7+FsK6%Qy\?'K3rkbBcq@YwiUxn'}9Hg\0w tI9ƀ5)PX3 rc myI̅0n\0=00ۑc\0墩!A@yū^93 \\i\0<{*}HkrqkuN;1[$=*%o띓݄7ØPMLl.)L*MP U1țgcC #WIbN (ky7SwV5ԮkuI{#2`^*ҿ{ \0Ӄ(BwƟۘ dᔦU|םD=/7HGH,\0o-C(s#kIDͳ*3_Uv\0Qu`P?=O *9fWw*|2*,"5<W0nl*]<ʾ__i"ҨP&C1gv9x?+ -C^I)-KY~Oˆ wf\0#g(d~y݈o0#D,*\0 3eV~JZMUրk`21fO*aA.k@ E~գ9GzA4*gu~Sr~o06ȤǷjli; ܚ/d[CVN~فnԊ4Yɕp|V|sN.k r-@*zORFϞfr3\ %Ґ 1}jHKIf+Ҭ]~~\0}<ö,g&[S.ANm|*l8(Z7]<o\M=K@`&tF)yVƃ jkS79/ҤmA\*AٚM_(J7[U`.Dd^i @ȸ);CUpfmݥ9HD̫8~2;UU*hFbэ|-9EX 7m:AoU;xIDV;O:Y3bdt _98-KB/CTQT)!fm-`[YnQK T$}x9Kx)*1#_<AF@wPثSƏ&5z z'B0BM[6ocHگIs,#tSV9Jg (tnIes;~/'Np #lD&IJ-$ٵ|²_2"@[#liWKYЮXf9$;쯧@jE Jl Zil7xa"$nK3 #QÇM&5CW7\tWޢ7sĉ"Tu{ AH#oc#E=B FXv9X໑K #CAN+ Dl3:;:_-meZӎ#u܍j7ZD{g,5N#1=YrA U *a6^d3_MŹ*]sSt]5-CR&:Hq#+]ꊔP],^LqeG*4bNSdyjŀVn )\0mm{eB5?+7;HxN.y(5FZϓ=@< BGKlłMM#::C/JWJ?2][os\-PE#*;C`Nl#IRN1Ek_7@ϯ l,0HQn #w[4llŸOH̐[~|yJa_2aOݾ@:V9wv W U--Snh-q }.šfO|#-6hK*\0ܕқH/0&Tz?`wtаg ~LH\0nh;qRh&ћrRTW˚-pCpFYk9RJF,KAƳ3w߂]{Itu˻yGgի!}ZG`"*BҰ _n8Z*sܐ3MgɗTx40Eb*( Z LKtmzpvyyPN=*7īˊ*,ArNd*8 3-~eS84%&3xZ;/8D9J<Mȕ_ 2}$;mݒ+$8'EȆ.d;y:P|\M6? Y~*-ٍx\bynPFvCnOi 1L;3``\0g!GrE:Xo4a.Ս,X[VP(1uNQOnjIf|/Eǚ[b 8Cr+ y\0)\0r^}nI2إ~4uzZzԓ\pxקp 'TEvY\D3#O6;RJz=FSo3:h~ qb˞c,5#4*<z6G!l ]Հ1m*-XQu_o eG䒗tx*f< DJAgWd49~}75փhR<;DB~t:dVlQJ:S*wc.lhFe+آ mK@ߙу~cOmNv.$wAZt*as| *ϽY ϗ÷T$t)L-ʧ'*Tm\0,uۼ*~{dS49_v5 ~R{kG|#Nv)4T3שNVr5/r{qtѮDY=`^ErrP+|ue?gZ447 H ģNppGG$ܨ+)ep:Ύ oԳu֦'kG|B pC쌷xT ٵK USg#`u_ qUA"f1uMC3q\%;%o\zC!K= Ѫhm0)w|YE1lx.cQK-/'ݹ&淆MޤsYYSHjP|t~괧F !aƀbstEN~COVr\0çĘ7Ѓn. yp*;ŕ$/ 9*}Dxn~3%u?-x9Sl$.m@k5Q _5ywwد Д"!!`tbdL1|qּѥTt\0 Jh%^,tg-.b2+l`ऊ-P#P1zH;($;e`+.,**?6P{ =','W*Ry}avbl@`ٵx@I/)x'婶2,zL@o )ĤRFҕ;^V6ALUF<J"9iBçf?@ *, G\2'b*UNKk\WsjXsA'!F$ƃyF*{qbYј]m06at'3T;hol*C=Gx:ƒbۂ zb{/s8e%- 9 gnhƂ5A3aU[L8f#Y/)xOf]wH@m?f5,i}TY\0#byΜ*Y`7CFn964ڳLvS?nQŎ{MyfYUl 0RBS5"\_}JE]DΰFLX"\0σJ %%/Sjsv#1JLa)ZT!&Pc9@8ɶ dnWCM_m80K"9w[l( ;$%ơQ3wDlj o8= 9qdS d ֨6ӒƩN?.Sw,$u44d*B22B 4082n4G*}s5<.:~fuF\ X.j`.!aq7ɟEʃnok(Oo:A\0 ڙ~EkJ=FjoCpѽ싚klȰ[La:5J%zgd{Q`4׀6)Ԕev@45mڢ9"-H]P nrNIa*ST.#h=s V_ oerG575Y0!4DY܇NNFPg aKďh*v4Mmd8д D9zW%$A_qGT6)n[PK*!rn1bv!(9q)̗hN6]f cIφ{FpBuS:&mar9QM !x* bYVC?FTn {4JYM=bNDN3 :k녍okz~B=Q`0Z[kO82 3ڮ/l@Y2؛:Jhf&Wj Q!*`͐u+iJ^T2fq0@zY!K5w7P@ d}WdE5j@Tugm8Y"mӮPl^K7s*2h Уt#+ȼwbYv8qYhV1{<Udc E]$jTh5}\w̉f!\0C *HAq|8dQ#\0#pŀirc;" {5 1Nie*O**Z9PHD8X { J&'2\0dI"g*r`oYh2}Bx|{if l@*[o8 JMVZ, &s]z@*C-wi{{ulFEYhI\0~SgTԨ ~@7]Ч/5yNJDН&ELgu1]?i/q*!w^\ys ?]!T"vMe_e[=CdqxPg q 3HmY0* W;Oޥt]c[/l/M&E}15]JK*$fQSPUɫXL:QfnҦv(Jq=z! \0CDJgF/7ƣv`Ð%bA8 ؟b _`&9-kW<j\]BcS &"i.i)}cYz*PqΑ߷{A#Q*? Y"&< 4c_DGR|XF]d Lu*j9d:ȈlN H*1QK`42GCɮԮBN$F0 W{Qtsϯ83*"*<r6 sGd3xygu# zc X Px R@s}}e0DJ,Cث5tމ!#gw#5# 'C?*`HF́2LE1CĤITuEpz;U yW¼X|~VDKżPTՔ6*g`Jqn mrHXdzUDnXכT|,Q'?6@#ƕ 1mῤ;w0D͒ݕ%lSoi2 ߳n]:?tjA-%|WE(?Rލ?Phgv`H37HE8\<h%ԗJ?J הo=`!Df\zM t1,&-,^wTq `QO0Z佸ni'(ɲ\ʸZ(M, _G:,Exsa$;"%*Z!Sz]m*%^M\Ķǃ%IQ\0h cj9rt-j!۩fdy[{r=# =*M3ىm*pc[k?e0P\~ʖ/V2!PF -~Xx!k/pӨc:JDDO7ɾfmZt%N?2sD5@I V%x}uq2|$`a`ds͎@mM6בQFQ2ED DlY!?x\0EiԴBjU:}Iel ; c~biM؎s*= @ k/δ]7Ia8ԂC`LM9Z{Nj)SJ AZ4G.Gs?0ӥREcdپF ۟\0 _*VS&+D,wU<`hC="z:ܴăd oGk(; *u Mf[K]&\26g?{* ڜgi9½sVNK;Ui%&'{cM0v&c| FK=gg\0 L)hGPnD;l a)% Smqz5&pǸbkyƔu |13մ$VшZY4 5-\0F;*l(f.RPU"gT)tr9P"m@ Ws2@v'**f*MdˊeéK'Ό~ "ښpsG[HKtUB{EPOrCtx)J~q|Pi)C F,to*=zv. t̑Mw*=*rl&(Ch}\0~i)HigLU X.$\0Vgm\0(8jn~f })}6[[ߪj}P`d* fIȹF#ڦHX<.C-xŘbv}Gdk6 n8^M0j&h^I^_*kdfFD"pKH)8ë[ R˔,;R1lQ,_ՅKd=DfG P76nLoMH8vgmQ+MҡR~4yuim6CZ_ :~N(!'dЊS=[k ')ZyE<]eUY1jkd֫Wny85ڛyis@]E|/m-̆0Ilb Ձ6ݸg}~:0y_YSt3]l&0ohoqy8g{oeL+uNfj΅iӗUJr wӉêYrRTVFBVR{9iŢR1P4r5[[4<7Uί{/d T: 3qDNa@mybn,l.@2CGd퐄I*K4=dWd5<xuin <*1*HӔtz.3"zbG mx`v**\0dLi".s,8{у@&Ύ r=i7]1@y}5v,GP˨j hCM|])E2NQ1yKhAPbbYewqYWN* foK=BCCt L@1<~@! )[(ÏmkOT-dtJEK,f(YfpJ9;"}u="ǧnP,OO/~LYj,i٢ha\w5Cӏ=$# b`VTƟ#'\4W1M/9^8\0^"^#dbO0{({ 'WΆf,CugER$j|2aj7e [*"h=" ֨eOuX%kmXa93(OYb`$sh~C *ESnz䉅?*tRS]Pp_ fqcO#1ژJE;Y+b[Y]<*Z]zٷw3Yc\kq3\X8L7~iJ& G[~_z֗r}W-l^7Kod5B嵓<Rs$A2LA TPvvf6(nq d){}bO* 2-G3ChgKtނg3+qYGhFd: B[ˉ|Ik״R=sb#La`.Ly_[غoQY'`_C,F#E m ~䚃\0:zr~n:<6W,S-%5&E \0*9Ht*2fVDr3;o $Qjj#-L-ܽgf\0Mb3UrO ±#~h.}*V*Uڲ iuMS-xT\F EW+ RKQdAdr].bz *|ӥE;^a{**r&1fiS]~!aX 7HӶy cm;Bl] Oga軨3zmu,@txmn0'ǟxWU\0# Lj]꧕0#K8+cUzX~)V,ȕzɮ1Pb ~|d8ѻ.ysIÝCMlG}PYjfk%)*o |ō0ʑo ntDI3i)*}*Ru2uG /V+&7nƕO<^,гYN/̅d ȸZЬԅt2H*gnbDת\0iQX3` I_2Lm5~#gݴX#2JQ-Þ[' M/AbҐn2_u&ld0[vQ)^Z<йN\I\0vrr 5wHgG6jd}$ hҫBH7?:wS ;ٖ&FUHW6*O_g ql0GbXr=4E=Z3?RzEMR y b@ԻiԎs QbPlnߕp\{QpLL }F0~x+=0VdHZ<^wKx~W;8 87]uSw<O/KYV"٪aMIaVls`j'iAgݦ!ȍMfJ K'N35&jˉƗ؟ﺔo¸(QB ʇ*nNIɆ4*M=QqFae۴ֿG~BLK2v 'Ag}'{ի!1Llt63mt=+b "dw"k%)m"\+,r{q<~\0*Yٕ -ڐ,tݶc6#Yt3~x[U$n͡~6*}_D\e4;c*I )Ãˀ[.M1Ɗ|L^ϴwvٚK"2UV|?pR!,[T2me%CDd~n[W@f_JϼA6":DrW^LƮ$mnUgԻ|zn$P 7[U®FCkvs?!zAt'@NjMGL2nuo |kpեK7.!?\D!Hv~c7 Rgq.rkЙVCV]WنH$=2tw0a(}**?o8ܪ˙\섮 *jź%E)[?e7Ab <@YyVfr(&{]8lA*M"!k5y16DK_:Jcq ri\İI'M=eL}!;x% 6Q:{B̏CTql`=i*w3Ho4]b!%/]0oN;Ľ%Mv^Js~Z_ZRvE=t ^}5[fJ]yR]dv56& .Dw\SҲt<8Qq1*An\0qٴ3 a2sٛL|?%ÐOkv(?QGW( |u@Rfx9xNx(٩1ln*/y_nR9,4q*W16$J1-P!O5GȦBǂyujq6$V.hg ҔTFcI}PCZ][kJm\\0pu!HWrkS@Ozm?fLz)|1 ]!Dvs7F籓q_F\;U7aGp@ }P[=#usGp M,BNO=f+5eS,NGDĨ`b\5kL5 BuMJ5 |z!m- `s/ 3~h,lʏ<&&CKj?ٽNLB( zUJ9gkBЏ?^E^sh}@y2\ 0v|X'k4Kfa0;Xq(Dlޙ@XT[&*̐\0(0ܑ$"傌VI*n`)e^mZ t|6*uy+D*G/lf\0 n\0\0#]\0\0\0\0\0 ~7\0\0!\0R\0e\0s\0i\0z\0e\0C\0h\0a\0r\0t\0.\ 0x\0l\0s\0\0\0 \0\0*2\0 \0\0\0\0\0 |
#2
![]() |
|||
|
|||
![]()
Be aware that few people will open your attachment.
The rule for the ng is NEVER attach anything. Just ask if someone will look at your workbook and if they reply YES, you can arrange to send it to them by email. -- steveB Remove "AYN" from email to respond "Janwillem van Dijk" wrote in message . nl... After a lot of trial and error I came up with the solution presented in the attachment for reformatting a chart such that the inside dimensions are exactly the ones you defined, e.g. a square of 70 x 70 mm. For the cases I needed (only XY-scatter) it worked fine but do not be surprised if miraculous things happen when you try it on your own charts; a lot of surprising phenomena, or hidden intelligence if you like, in the chart world. Thank you for the suggestions in this news group. Janwillem P.S. I am from the ALGOL-60 days and have ever since made an effort of not using BASIC. I would therefore not be surprised when some of you can improve considerably on the coding. The xls file is compressed with the Open Source 7-Zip http://www.7-zip.org/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Plotting 4 dimensions in a chart | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |