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

[µo°Ý] ¹Ïªí¿ï¾Ü¸ê®ÆªºÄæ¦C¤¬´«?

[µo°Ý] ¹Ïªí¿ï¾Ü¸ê®ÆªºÄæ¦C¤¬´«?

§Q¥Î¿ý»s¥¨¶°¤j·§¤F¸Ñ´¡¤J¦pªí»yªk¤§«á§ï¼g
¯à¦¨¥\¥Í¦¨¹Ïªí©M½Õ¾ã®æ¦¡
¦ý¹w³]ªºÄæ¦C¸ê®Æ«o¬O¬Û¤Ïªº
¥²¶·¤â°Ê¿ï¨ú­×¥¿
¿ý»s¥¨¶°¦ü¥GµLªk°O¿ý³o°Ê§@
½Ð°Ý¸Ó«ç»ò°µ©O? ÁÂÁÂ!
§Úªºµ{¦¡½X
  1.     ActiveSheet.Shapes.AddChart(xlXYScatter).Select
  2.     ActiveChart.SetSourceData Source:=Union(Range(Cells(4, 4), Cells(Range("D4").End(xlDown).Row, 4)), Range(Cells(4, 10), Cells(Range("J4").End(xlDown).Row, 10)))
½Æ»s¥N½X

Capture2.PNG (20.41 KB)

Capture2.PNG

¦^´_ 1# lalalada


   ¤Þ¤°VBE»¡©ú¡APlotBy ¿ï¥Î Variant ·|«ü©wø»s¸ê®Æªº¤è¦¡¡C¥i¥H¬°¤U¦C¨ä¤¤¤@­Ó XlRowCol ±`¼Æ¡GxlColumns ©Î xlRows¡C
  1.     ActiveChart.SetSourceData Source:=Union(Range(Cells(4, 4), Cells(Range("D4").End(xlDown).Row, 4)), Range(Cells(4, 10), Cells(Range("J4").End(xlDown).Row, 10))), PlotBy:=xlColumns
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD