- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
¨Sª`·N§AÁÙ¤£¯à¤U¸ü- Sub Macro1()
- Dim c As Range, x%, y%
- [b2:b3] = [b2:b3].Value
- For Each c In Range([a8], [a8].End(4))
- If c >= [b2] And x = 0 Then x = c.Row
- If c > [b3] And y = 0 Then y = c.Row - 1
- Next
- If x = 0 Then x = 8
- If y = 0 Then y = [a65536].End(3).Row
- ActiveSheet.ChartObjects(1).Select
- ' Charts.Add
- ActiveChart.ChartType = xlLineMarkers
- ActiveChart.SetSourceData Source:=Sheets("½u¹Ï").Range("A" & x & ":B" & y), PlotBy:=xlColumns
- ActiveChart.Location Where:=xlLocationAsObject, Name:="½u¹Ï"
- ActiveChart.HasDataTable = False
- End Sub
½Æ»s¥N½X |
|