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

[µo°Ý] ªÑ²¼¹Ï¤W¦A¥[§é½u¹Ïªº°ÝÃD

[µo°Ý] ªÑ²¼¹Ï¤W¦A¥[§é½u¹Ïªº°ÝÃD

½Ð°Ý¦U¦ì«e½ú¡A¦pªGªÑ²¼¹Ï¬O¥Îexcel¤º«Øªº¹Ïªí¡A¬O¤£¬O´Nºâ¥ÎVBAªº¤è¦¡
¦p
  1. ActiveChart.SeriesCollection.NewSeries
  2. .Values = "=sheet1!R6C8:R70C8"
  3. .ChartType = xlLine
½Æ»s¥N½X
ªº¤è¦¡¤U¥h¼g,¤]¨S¦³¿ìªk­×§ï¹ÏªíÃþ«¬

¦Ó¤@©w­n¦Û¤v­«¼g¤@­ÓªÑ²¼¹ÏªºcodeµM«á¦Aªþ¥[¤W§é½u¹Ïªºcode¶Ü?
ÁÙ¬O§Ú¥u¬O¥Î¿ùcode?

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD