Guest User

Untitled

a guest
Apr 22nd, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub 作圖()
  2.     Range("A:A,B:B,D:D,F:F,H:H,J:J,L:L,N:N,P:P,R:R,T:T,V:V,X:X,Z:Z").Select
  3.     Range("P1").Activate
  4.     ActiveSheet.Shapes.AddChart2(240, xlXYScatterSmooth).Select
  5.     ActiveChart.SetSourceData Source:=Range( _
  6.         "A:A,B:B,D:D,F:F,H:H,J:J,L:L,N:N,P:P,R:R,T:T,V:V,X:X,Z:Z" _
  7.         )
  8.     ActiveChart.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
  9.     ActiveChart.SetElement (msoElementPrimaryValueAxisTitleAdjacentToAxis)
  10.     ActiveChart.SetElement (msoElementChartTitleNone)
  11.     ActiveChart.SetElement (msoElementLegendRight)
  12.     ActiveChart.Axes(xlValue, xlPrimary).HasTitle = True
  13.     ActiveChart.Axes(xlCategory).AxisTitle.Select
  14.     ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "V (V)"
  15.     Selection.Format.TextFrame2.TextRange.Characters.Text = "V (V)"
  16.     With Selection.Format.TextFrame2.TextRange.Characters(1, 5).ParagraphFormat
  17.         .TextDirection = msoTextDirectionLeftToRight
  18.         .Alignment = msoAlignCenter
  19.     End With
  20.     With Selection.Format.TextFrame2.TextRange.Characters(1, 5).Font
  21.         .BaselineOffset = 0
  22.         .Bold = msoFalse
  23.         .NameComplexScript = "+mn-cs"
  24.         .NameFarEast = "+mn-ea"
  25.         .Fill.Visible = msoTrue
  26.         .Fill.ForeColor.RGB = RGB(89, 89, 89)
  27.         .Fill.Transparency = 0
  28.         .Fill.Solid
  29.         .Size = 10
  30.         .Italic = msoFalse
  31.         .Kerning = 12
  32.         .Name = "+mn-lt"
  33.         .UnderlineStyle = msoNoUnderline
  34.         .Strike = msoNoStrike
  35.     End With
  36.     ActiveChart.Axes(xlValue).AxisTitle.Select
  37.     ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Text = "I (A)"
  38.     Selection.Format.TextFrame2.TextRange.Characters.Text = "I (A)"
  39.     With Selection.Format.TextFrame2.TextRange.Characters(1, 5).ParagraphFormat
  40.         .TextDirection = msoTextDirectionLeftToRight
  41.         .Alignment = msoAlignCenter
  42.     End With
  43.     With Selection.Format.TextFrame2.TextRange.Characters(1, 5).Font
  44.         .BaselineOffset = 0
  45.         .Bold = msoFalse
  46.         .NameComplexScript = "+mn-cs"
  47.         .NameFarEast = "+mn-ea"
  48.         .Fill.Visible = msoTrue
  49.         .Fill.ForeColor.RGB = RGB(89, 89, 89)
  50.         .Fill.Transparency = 0
  51.         .Fill.Solid
  52.         .Size = 10
  53.         .Italic = msoFalse
  54.         .Kerning = 12
  55.         .Name = "+mn-lt"
  56.         .UnderlineStyle = msoNoUnderline
  57.         .Strike = msoNoStrike
  58.     End With
  59.     ' 設定位置
  60.    With ActiveChart.Parent
  61.     .Top = Range("D10").Top
  62.     .Left = Range("D10").Left
  63.     End With
  64.    
  65. End Sub
Advertisement
Add Comment
Please, Sign In to add comment