ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¦p¦ó¨Ï¹Ïªí¤W¦b0ÂI¤W¤Uªº«ü¼ÐÃC¦â¤À§O¥H¤£¦PÃC¦â¼Ð¥Ü¡H

[µo°Ý] ½Ð°Ý¦p¦ó¨Ï¹Ïªí¤W¦b0ÂI¤W¤Uªº«ü¼ÐÃC¦â¤À§O¥H¤£¦PÃC¦â¼Ð¥Ü¡H

½Ð°Ý:
¦bExcel¹Ïªí¤Wªº«ü¼Ð§¡¬°¤@ºØÃC¦â¼Ð¥Ü¡A¦p¤U¦Cªþ¹Ï¡C
¦pªG§Ú·Q­n±N¥¿­È»P­t­È³¡¤À§O¥H¤£¦PÃC¦â¨Ó°Ï¤Àªí¹F¡A¥H¤è«K¾\Äý¡F
½Ð±Ð¦U¦ì¤j¤j¡AExcel¹Ïªí­n¦p¦ó³]©w¥¦©O¡H (¦p¹Ï¥Ü¤§¥k¤U¨¤¼Ð¥Üªº¤p¹Ï¥Ü)

¥»©«³Ì«á¥Ñ gstone ©ó 2012-3-30 10:35 ½s¿è

¦^´_ 1# c_c_lai

­ì¤@Äæ¦ìªº¼Æ­È§ï³]¨âÄæ
½Ð¸Õ¸Õ¬Ý

­Y¬O½u¹Ï
07¥H«áªºª©¥»¦ü¥G¤£»Ý³]NA()
«Ý¬dÃÒ~~~
Book1.rar (2.09 KB)

TOP

¯u¤£¦n·N«ä¡A§ÚªºÅv­­¤£¨¬µLªk¤U¸ü Book1.rar
§Úªººô§}¬O¡G [email protected]
¯à§_ E-Mail µ¹§Ú¡AÁÂÁ±z¡I

TOP

¥»©«³Ì«á¥Ñ gstone ©ó 2012-3-30 11:23 ½s¿è

¦^´_ 3# c_c_lai

¨Sª`·N¨ìÅv­­°ÝÃD~~~
½Ð¨ì³o¤U¸ü

Book1.rar
http://www.funp.net/616974

TOP

½Ð¨ì³o¤U¸ü
Book1.rar
Book1 ¡H¡H¡H  ³Â·ÐE-Mail µ¹§Ú¡AÁÂÁ±z¡I
­ì¤@Äæ¦ìªº¼Æ­È§ï³]¨âÄæ¡H

TOP

§KªÅªººô§}µLªkÅã¥Ü¶Ü?
ok ~~~ mail ¹L¥h¤F

TOP

¨S°ÝÃDªº~~
ªº½T¬O«Ü¤Ö¹J¨ì¥Îexcel§@«ü¼Ð¹Ïªº¦P¦n¡AÅwªï¤¬¬Û¬ã¨s¡IÁöµM¬O®ö¶O¤FÀx¦sªÅ¶¡¦ý¥Øªº«o¹F¨ì¡C
¥t¥~¡A§Ú´¿¦b¦¹½×¾Â´£°Ý¹L¦³Ãö¹Ïªí¤º¿ï¨ú¸ê®Æ¶µ¡G  =²Î­p¹Ïªí!$I$2I$904
¥Ø«e½d³ò°Ï¶¡§Ú¬O¥Î¼g¦ºªº¤è¦¡¡A¦¹³B¯à§_¨Ï¥Î¾÷°Ê§PÂ_³Ì«á¤§¦æ¼Æ¦Ó¥ç¯à¦P¨B
¼g¤J¨ì¤½¦¡¸Ì¡A°²³]¥Ø«e¸ê®Æ¤w¶×¤J¨ì 1024 ¦C¡A¦¹®É¤½¦¡«h¦P¨B­×¥¿¬° =²Î­p¹Ïªí!$I$2I$1024
¦p¦¹«K¥i¾÷°Ê¦P¨B±±¨î¹ê»Ú¶×¤J¹Ïªí¸ê®Æ¡A¦Ó±N¥¦±o¥H§¹¾ã¥¿½T§e²{¡H

TOP

¦^´_ 1# c_c_lai
­n§â¤j©ó0©M¤p©ó0ªº«ü¼Ð¶q ¦bChart¤¤¥Î¤£¦PªºÃC¦âªí¥Ü ¥i¥ÎInvertColor ¨Ó§¹¦¨
°²³]§Aªº«ü¼Ð§Ç¦C¬OSeriesCollection(2)
Code ¥i¥H¦p¤U :
ActiveChart.SeriesCollection(2).InvertIfNegative = True
ActiveChart.SeriesCollection(2).InvertColor = RGB(n1, n2,n3)
Alex

TOP

AlexLiou ¤j¤j¡A¦]¤p§Ì¸ê¾ú©|²L¡A±z¯à§_E-Mail¤@­ÓSampleÅý¤p§Ì¹ê»Ú¤F¸Ñ¦p¦ó¹B¥Î©O¡H
«D±`·P¿E±z¡I

TOP

¦^´_ 9# c_c_lai
sample¤w±Hµ¹§A
°£¤F¹s¶b¤W¤U«ü¼ÐÃC¦â¤£¦P¥~
§A¥t¥~°ÝªºÃ¸¹Ï¸ê®Æ¨Ó·½¤£¼g¦ºªº±¡§Î
¸Ì­±¤]¦³
Alex

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD