{"id":9299,"date":"2020-02-06T06:00:00","date_gmt":"2020-02-05T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=9299"},"modified":"2019-12-25T16:23:27","modified_gmt":"2019-12-25T07:23:27","slug":"excel-vba-%e3%81%a7-series-%e3%82%aa%e3%83%96%e3%82%b8%e3%82%a7%e3%82%af%e3%83%88%e3%82%92%e3%82%bd%e3%83%bc%e3%83%88%e3%81%a7%e3%81%8d%e3%81%aa%e3%81%8b%e3%81%a3%e3%81%9f%e8%a9%b1","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=9299","title":{"rendered":"EXCEL VBA \u3067 Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u30bd\u30fc\u30c8\u3067\u304d\u306a\u304b\u3063\u305f\u8a71"},"content":{"rendered":"\n

\u3000Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092 PlotOrder \u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u30bd\u30fc\u30c8\u3059\u308b\u5fc5\u8981\u304c\u3042\u3063\u305f\u8a71<\/a>\u3092\u3057\u305f\uff0e\u4eca\u56de\uff0cSeries \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u30bd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306b Collection \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u4ee3\u5165\u3057\u305f\u306e\u3060\u304c\uff0c\u914d\u5217\u306e\u6700\u7d42\u8981\u7d20\u3092\u53d6\u5f97\u3059\u308b\u3068\u3053\u308d\u3067\u5b9f\u884c\u6642\u30a8\u30e9\u30fc\u3068\u306a\u308a\uff0c\u89e3\u6c7a\u3057\u3066\u3044\u306a\u3044\uff0e<\/p>\n

\u3000Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u30bd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306e\u65b9\u6cd5\u3068\u3057\u3066\u306f\uff0c\u5143\u306e\u30c7\u30fc\u30bf\u3067\u6bd4\u8f03\u3059\u308b\u65b9\u6cd5\u3068\uff0cSeries \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u6700\u7d42 Point \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e Top \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u6bd4\u8f03\u3059\u308b\u65b9\u6cd5\u304c\u3042\u308b\uff0e<\/p>\n

\u3000\u610f\u5473\u3068\u3057\u3066\u306f\u3069\u3061\u3089\u3082\u540c\u3058\u3060\u304c\uff0c\u3069\u3046\u305b\u306a\u3089\u5143\u306e\u30c7\u30fc\u30bf\u3067\u6bd4\u8f03\u3059\u308b\u306e\u304c\u738b\u9053\u3068\u601d\u308f\u308c\u305f\u306e\u3067\u305d\u3061\u3089\u3092\u8a66\u3057\u305f\u306e\u3060\u304c\uff0c\u4eca\u306e\u81ea\u5206\u306b\u306f\u30b9\u30ad\u30eb\u4e0d\u8db3\u3067\u624b\u306b\u8ca0\u3048\u306a\u304b\u3063\u305f\uff0e\u6094\u3057\u3044\uff0e<\/p>\n

<\/p>\n

Collection \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u4ee3\u5165\u3057\u305f Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304b\u3089 Values \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u306f\u4e0d\u53ef\u80fd<\/h3>\n

\u3000\u7406\u7531\u306f\u4e0d\u660e\u3060\u304c\uff0cSeries \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092 Collection \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u4ee3\u5165\u3057\u3066\u3057\u307e\u3046\u3068 Variant \u578b\u914d\u5217\u3067\u3042\u308b Values \u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u500b\u3005\u306e\u8981\u7d20\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u304b\u3063\u305f\uff0e\u3053\u308c\u304c\uff0c\u76f4\u63a5 Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u7d4c\u7531\u3067\u306a\u3089\u53d6\u5f97\u3067\u304d\u308b\u306e\u306f\u4e0d\u53ef\u89e3\u3067\u3042\u308b\uff0e<\/p>\n

Dim mySeries    As Series\nDim k           As Long\nDim myColl      As Collection\nDim p           As Long\nDim q           As Long\n\nSet myColl = New Collection\nFor Each mySeries In .SeriesCollection\n    With mySeries\n        Set myPoint = .Points.Item(.Points.Count)\n        Debug.Print .Name, .Values(6)\n        myColl.Add Item:=mySeries\n    End With\nNext mySeries\n\nFor p = 1 To myColl.Count\n    'Debug.Print myColl(p).Name, TypeName(myColl(p).XValues), TypeName(myColl(p).Values)\n    'Debug.Print myColl(p).Name, myColl(p).Points(1).Top, myColl(p).Points(6).Top\n    'Debug.Print myColl(p).Name, VarType(myColl(p).Values), LBound(myColl(p).Values), UBound(myColl(p).Values)\n    'Debug.Print myColl(p).Values(UBound(myColl(p).Values))\n    '\u5b9f\u884c\u6642\u30a8\u30e9\u30fc '451': Property Let\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304c\u5b9a\u7fa9\u3055\u308c\u3066\u304a\u3089\u305a\uff0cProperty Get\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304b\u3089\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u8fd4\u3055\u308c\u307e\u305b\u3093\u3067\u3057\u305f\n    For q = myColl.Count To p Step -1\n        Debug.Print myColl(p).Values(6)\n    Next q\nNext p\n<\/pre>\n
\u3000\u4e0a\u8a18\u306e\u30b3\u30fc\u30c9\u306e\u3046\u3061\uff0c11 \u884c\u76ee\u306f\u6b63\u5e38\u306b\u52d5\u4f5c\u3059\u308b\uff0e\u3057\u304b\u3057\uff0c20 \u884c\u76ee\u3068 23 \u884c\u76ee\u306f\u5b9f\u884c\u6642\u30a8\u30e9\u30fc ‘451’ \u304c\u767a\u751f\u3059\u308b\uff0e<\/p>\n
\"\u5b9f\u884c\u6642\u30a8\u30e9\u30fc<\/a>
\u5b9f\u884c\u6642\u30a8\u30e9\u30fc ‘451’: Property Let\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304c\u5b9a\u7fa9\u3055\u308c\u3066\u304a\u3089\u305a\uff0cProperty Get\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304b\u3089\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u8fd4\u3055\u308c\u307e\u305b\u3093\u3067\u3057\u305f<\/figcaption><\/figure>\n
\u3000\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u30b3\u30fc\u30c9\u304c\u505c\u6b62\u3057\u305f\u6642\u70b9\u3067\u30ed\u30fc\u30ab\u30eb\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u898b\u3066\u307f\u308b\uff0eValues \u30d7\u30ed\u30d1\u30c6\u30a3\u306f Variant \u578b\u306e\u914d\u5217\u306b\u306a\u3063\u3066\u304a\u308a\uff0c\u8981\u7d20\u306b\u5024\u304c\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u306e\u304c\u5206\u304b\u308b\uff0e<\/p>\n
\"\u30ed\u30fc\u30ab\u30eb\u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u89b3\u5bdf\"<\/a>
\u30ed\u30fc\u30ab\u30eb\u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u89b3\u5bdf<\/figcaption><\/figure>\n
\u914d\u5217\u3092 Variant \u578b\u5909\u6570\u306b\u4ee3\u5165\u3059\u308b\u3068\u53d6\u5f97\u3067\u304d\u308b<\/h3>\n
\u3000\u305d\u306e\u5f8c\u306e\u30c6\u30b9\u30c8\u3067\uff0cCollection \u306e\u8981\u7d20\u3067\u3042\u308b Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e Values \u30d7\u30ed\u30d1\u30c6\u30a3\u3092 Variant \u578b\u306e\u5909\u6570\u306b\u4ee3\u5165\u3059\u308b\u3068\uff0c\u30eb\u30fc\u30d7\u306b\u3088\u308a\u5404\u8981\u7d20\u3092\u53d6\u5f97\u3067\u304d\u305f\uff0e\u4e0b\u8a18\u306e\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\u306b\u306f 2 \u3064\u306e Debug.Print<\/span> \u304c\u3042\u308b\u304c\uff0c\u3069\u3061\u3089\u3082\u52d5\u4f5c\u3059\u308b\uff0e<\/p>\n
Dim r           As Long\nDim myVar       As Variant\nDim myAr        As Variant\nr = 1\nFor Each myVar In myColl(p).Values\n    Debug.Print r, myVar\n    r = r + 1\nNext myVar\nmyAr = myColl(p).Values\nFor r = LBound(myAr) To UBound(myAr)\n    Debug.Print r, myAr(r)\nNext r<\/pre>\n
\u3000\u3053\u306e\u7dda\u3067\u9032\u3081\u308b\u306a\u3089 Variant \u578b\u5909\u6570\u3092\u3082\u3046\u4e00\u3064\u5ba3\u8a00\u3057\u3066\u30d0\u30d6\u30eb\u30bd\u30fc\u30c8\u3059\u308c\u3070\u3088\u3044\uff0e<\/p>\n
\u3000\u30d0\u30d6\u30eb\u30bd\u30fc\u30c8\u306f VBA Collection\u306e\u30d0\u30d6\u30eb\u30bd\u30fc\u30c8 \uff5e \u5358\u7d14\u5b9f\u88c5\u304b\u3089\u30ea\u30d5\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u305f\u6c4e\u7528\u5316\u307e\u3067<\/a> \u304b\u3089\u5f15\u7528\u3057\u305f\uff0e<\/p>\n
Dim myAr1       As Variant\nDim myAr2       As Variant\nFor p = 1 To myColl.Count                \n    myAr1 = myColl(p).Values\n    myAr1 = myAr1(UBound(myAr1))\n    For q = myColl.Count To p Step -1\n        myAr2 = myColl(q).Values\n        myAr2 = myAr2(UBound(myAr2))\n        Debug.Print myAr1, myAr2\n        If myAr1 > myAr2 Then\n            CollectionSwap myColl, p, q\n        End If\n    Next q\nNext p\n\nSub CollectionSwap(C As Collection, Index1 As Long, Index2 As Long)\nDim Item1 As Variant\nDim Item2 As Variant\n\nIf IsObject(C.Item(Index1)) Then\n    Set Item1 = C.Item(Index1)\nElse\n    Let Item1 = C.Item(Index1)\nEnd If\n\nIf IsObject(C.Item(Index2)) Then\n    Set Item2 = C.Item(Index2)\nElse\n    Let Item2 = C.Item(Index2)\nEnd If\n\nC.Add Item1, after:=Index2\nC.Remove Index2\nC.Add Item2, after:=Index1\nC.Remove Index1\nEnd Sub<\/pre>\n
\u30bd\u30fc\u30c8\u306e\u7d50\u679c<\/h4>\n
\u3000\u4e0b\u8a18\u306e\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\u3092\u30bd\u30fc\u30c8\u524d\u3068\u30bd\u30fc\u30c8\u5f8c\u306b\u7f6e\u3044\u3066\uff0c\u7d50\u679c\u3092\u6bd4\u8f03\u3059\u308b\uff0e<\/p>\n
For r = 1 To myColl.Count\n    myVar = myColl(r).Values\n    myVar = myVar(UBound(myVar))\n    Debug.Print r, myColl(r).Name, myVar\nNext r<\/pre>\n
\u3000\u3055\u3066\uff0c\u7d50\u679c\u3067\u3042\u308b\u304c\uff0c\u5c11\u3057\u4e0d\u53ef\u89e3\u306a\u3082\u306e\u3068\u306a\u3063\u305f\uff0e\u4f8b\u3068\u3057\u3066\u6c96\u7e04\u770c\u306e\u7d50\u679c\u3092\u793a\u3059\uff0e\u306a\u3093\u3068\u306a\u304f\u6607\u9806\u306b\u898b\u3048\u308b\u304c\uff0c\u6240\u3005\u304a\u304b\u3057\u3044\uff0e<\/p>\n
 1            \u591a\u826f\u9593\u6751       738 \n 2            \u4f0a\u662f\u540d\u6751       1112 \n 3            \u5317\u5927\u6771\u6751       487 \n 4            \u4e45\u7c73\u5cf6\u753a       4665 \n 5            \u6e21\u540d\u559c\u6751       219 \n 6            \u7c9f\u56fd\u6751         516 \n 7            \u5ea7\u9593\u5473\u6751       570 \n 8            \u6e21\u5609\u6577\u6751       641 \n 9            \u4f0a\u5e73\u5c4b\u6751       878 \n 10           \u5357\u5927\u6771\u6751       1039 \n 11           \u6771\u6751           1222 \n 12           \u4e0e\u90a3\u56fd\u753a       1421 \n 13           \u5317\u4e2d\u57ce\u6751       16181 \n 14           \u897f\u539f\u753a         29299 \n 15           \u5927\u5b9c\u5473\u6751       2219 \n 16           \u91d1\u6b66\u753a         11249 \n 17           \u672c\u90e8\u753a         10812 \n 18           \u4f0a\u6c5f\u6751         2418 \n 19           \u56fd\u982d\u6751         3011 \n 20           \u7af9\u5bcc\u753a         3752 \n 21           \u5b9c\u91ce\u5ea7\u6751       6495 \n 22           \u4eca\u5e30\u4ec1\u6751       8825 \n 23           \u6069\u7d0d\u6751         11926 \n 24           \u5609\u624b\u7d0d\u753a       12191 \n 25           \u4e0e\u90a3\u539f\u753a       18715 \n 26           \u4e2d\u57ce\u6751         25179 \n 27           \u5317\u8c37\u753a         29938 \n 28           \u516b\u91cd\u702c\u753a       32308 \n 29           \u8aad\u8c37\u6751         40467 \n 30           \u5bae\u53e4\u5cf6\u5e02       41289 \n 31           \u8c4a\u898b\u57ce\u5e02       69660 \n 32           \u77f3\u57a3\u5e02         45417 \n 33           \u540d\u8b77\u5e02         61543 \n 34           \u5357\u98a8\u539f\u753a       42609 \n 35           \u5357\u57ce\u5e02         44923 \n 36           \u7cf8\u6e80\u5e02         57254 \n 37           \u5b9c\u91ce\u6e7e\u5e02       102606 \n 38           \u6d66\u6dfb\u5e02         117418 \n 39           \u3046\u308b\u307e\u5e02       117934 \n 40           \u6c96\u7e04\u5e02         148791 \n 41           \u90a3\u8987\u5e02         300368 <\/pre>\n
\u3000\u3053\u3061\u3089\u306f\u30bd\u30fc\u30c8\u524d\u3067\u3042\u308b\uff0e<\/p>\n
 1            \u4e0e\u90a3\u56fd\u753a       1421 \n 2            \u7af9\u5bcc\u753a         3752 \n 3            \u591a\u826f\u9593\u6751       738 \n 4            \u516b\u91cd\u702c\u753a       32308 \n 5            \u4e45\u7c73\u5cf6\u753a       4665 \n 6            \u4f0a\u662f\u540d\u6751       1112 \n 7            \u4f0a\u5e73\u5c4b\u6751       878 \n 8            \u5317\u5927\u6771\u6751       487 \n 9            \u5357\u5927\u6771\u6751       1039 \n 10           \u6e21\u540d\u559c\u6751       219 \n 11           \u7c9f\u56fd\u6751         516 \n 12           \u5ea7\u9593\u5473\u6751       570 \n 13           \u6e21\u5609\u6577\u6751       641 \n 14           \u5357\u98a8\u539f\u753a       42609 \n 15           \u4e0e\u90a3\u539f\u753a       18715 \n 16           \u897f\u539f\u753a         29299 \n 17           \u5317\u4e2d\u57ce\u6751       16181 \n 18           \u5317\u8c37\u753a         29938 \n 19           \u5609\u624b\u7d0d\u753a       12191 \n 20           \u8aad\u8c37\u6751         40467 \n 21           \u4f0a\u6c5f\u6751         2418 \n 22           \u91d1\u6b66\u753a         11249 \n 23           \u6069\u7d0d\u6751         11926 \n 24           \u672c\u90e8\u753a         10812 \n 25           \u4eca\u5e30\u4ec1\u6751       8825 \n 26           \u6771\u6751           1222 \n 27           \u5927\u5b9c\u5473\u6751       2219 \n 28           \u56fd\u982d\u6751         3011 \n 29           \u5357\u57ce\u5e02         44923 \n 30           \u5bae\u53e4\u5cf6\u5e02       41289 \n 31           \u3046\u308b\u307e\u5e02       117934 \n 32           \u8c4a\u898b\u57ce\u5e02       69660 \n 33           \u6c96\u7e04\u5e02         148791 \n 34           \u7cf8\u6e80\u5e02         57254 \n 35           \u540d\u8b77\u5e02         61543 \n 36           \u6d66\u6dfb\u5e02         117418 \n 37           \u77f3\u57a3\u5e02         45417 \n 38           \u5b9c\u91ce\u6e7e\u5e02       102606 \n 39           \u90a3\u8987\u5e02         300368 \n 40           \u5b9c\u91ce\u5ea7\u6751       6495 \n 41           \u4e2d\u57ce\u6751         25179 <\/pre>\n
\u3000\u304a\u305d\u3089\u304f\u3069\u3053\u304b\u3067\u30b3\u30fc\u30c9\u306e\u8ee2\u8a18\u30df\u30b9\u3092\u3057\u3066\u3044\u308b\uff0e<\/p>\n
Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e PlotOrder \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u5909\u66f4\u3059\u308b\u65b9\u6cd5\u306f\uff1f<\/h3>\n
\u3000\u3082\u3046\u5c11\u3057\u8003\u5bdf\u3092\u9032\u3081\u3066\uff0c\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u793a\u3059 Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u304a\u3044\u3066\u306f .NewSeries \u30e1\u30bd\u30c3\u30c9\u3067\u8ffd\u52a0\u3055\u308c\u305f\u9806\u306b .PlotOrder \u30d7\u30ed\u30d1\u30c6\u30a3\u304c\u5897\u3048\u3066\u3044\u304f\u3053\u3068\u3092\u601d\u3044\u51fa\u305d\u3046\uff0ePlotOrder \u30d7\u30ed\u30d1\u30c6\u30a3\u306f SeriesCollection \u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306b\u3082\u306a\u3063\u3066\u3044\u308b\uff0e<\/p>\n
\u3000\u4e8b\u5b9f\uff0cSeries \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e PlotOrder \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3067\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u9806\u756a\u3092\u5909\u66f4\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u308b\uff0e\u3053\u308c\u3092\u30bd\u30fc\u30c8\u306b\u4f7f\u3048\u306a\u3044\u3060\u308d\u3046\u304b\uff0e<\/p>\n
Dim k           As Long\n'Dim myColl      As Collection\nDim p           As Long\nDim q           As Long\nDim r           As Long\nDim myVar       As Variant\nDim myAr        As Variant\n\nDim myVar1      As Variant\nDim myVar2      As Variant\nDim myAr1       As Variant\nDim myAr2       As Variant\nDim myLong1     As Long\nDim myLong2     As Long\n\nFor p = 1 To .SeriesCollection.Count - 1\n    Set myVar1 = .SeriesCollection(p)       'Series\n    myAr1 = myVar1.Values                   'Variant()\n    myLong1 = myAr1(UBound(myAr1))          'Item\n    'Debug.Print p, myLong1\n    For q = .SeriesCollection.Count To p + 1 Step -1\n        Set myVar2 = .SeriesCollection(q)   'Series\n        myAr2 = myVar2.Values               'Variant()\n        myLong2 = myAr2(UBound(myAr2))      'Item\n        'Debug.Print q, myLong2\n        If myLong1 > myLong2 Then\n                        \n            '(6)-1\n            'Set myVar = myVar1\n            'Set myVar1 = myVar2\n            'Set myVar2 = myVar\n            \n            '(6)-2\n            myCht.SeriesCollection(p).PlotOrder = q\n            '(6)-3\n            'myCht.SeriesCollection(q).PlotOrder = p\n            \n            '(6)-4\n            '.SeriesCollection(p) = myVar1\n            '.SeriesCollection(q) = myVar2\n        End If\n                \n        Next q\nNext p\n            \nFor Each mySeries In .SeriesCollection\n    Debug.Print mySeries.PlotOrder, mySeries.Name, mySeries.Values(6)\nNext mySeries<\/pre>\n
(6)-2 \u306e\u7d50\u679c<\/h4>\n
\u3000\u3053\u308c\u3082\u7d50\u679c\u304c\u304a\u304b\u3057\u3044\uff0e\u4f55\u3068\u306a\u304f\u6607\u9806\u306b\u898b\u3048\u308b\u7a0b\u5ea6\u3067\uff0c\u5b9f\u969b\u306b\u306f\u3081\u3061\u3083\u304f\u3061\u3083\u3060\uff0e<\/p>\n
 1            \u6771\u6751           1222 \n 2            \u5b9c\u91ce\u5ea7\u6751       6495 \n 3            \u4e2d\u57ce\u6751         25179 \n 4            \u56fd\u982d\u6751         3011 \n 5            \u6e21\u5609\u6577\u6751       641 \n 6            \u5317\u5927\u6771\u6751       487 \n 7            \u591a\u826f\u9593\u6751       738 \n 8            \u4eca\u5e30\u4ec1\u6751       8825 \n 9            \u4e45\u7c73\u5cf6\u753a       4665 \n 10           \u5357\u5927\u6771\u6751       1039 \n 11           \u6e21\u540d\u559c\u6751       219 \n 12           \u7c9f\u56fd\u6751         516 \n 13           \u5ea7\u9593\u5473\u6751       570 \n 14           \u4f0a\u5e73\u5c4b\u6751       878 \n 15           \u4f0a\u662f\u540d\u6751       1112 \n 16           \u4f0a\u6c5f\u6751         2418 \n 17           \u516b\u91cd\u702c\u753a       32308 \n 18           \u5927\u5b9c\u5473\u6751       2219 \n 19           \u4e0e\u90a3\u56fd\u753a       1421 \n 20           \u7af9\u5bcc\u753a         3752 \n 21           \u672c\u90e8\u753a         10812 \n 22           \u91d1\u6b66\u753a         11249 \n 23           \u6069\u7d0d\u6751         11926 \n 24           \u5bae\u53e4\u5cf6\u5e02       41289 \n 25           \u5357\u98a8\u539f\u753a       42609 \n 26           \u5609\u624b\u7d0d\u753a       12191 \n 27           \u4e0e\u90a3\u539f\u753a       18715 \n 28           \u5317\u4e2d\u57ce\u6751       16181 \n 29           \u897f\u539f\u753a         29299 \n 30           \u5317\u8c37\u753a         29938 \n 31           \u8aad\u8c37\u6751         40467 \n 32           \u5357\u57ce\u5e02         44923 \n 33           \u5b9c\u91ce\u6e7e\u5e02       102606 \n 34           \u77f3\u57a3\u5e02         45417 \n 35           \u8c4a\u898b\u57ce\u5e02       69660 \n 36           \u3046\u308b\u307e\u5e02       117934 \n 37           \u7cf8\u6e80\u5e02         57254 \n 38           \u540d\u8b77\u5e02         61543 \n 39           \u6d66\u6dfb\u5e02         117418 \n 40           \u6c96\u7e04\u5e02         148791 \n 41           \u90a3\u8987\u5e02         300368 <\/pre>\n
(6)-3 \u306e\u7d50\u679c<\/h4>\n
\u3000\u6841\u6570\u7a0b\u5ea6\u3057\u304b\u6607\u9806\u306b\u306a\u3063\u3066\u3044\u306a\u3044\uff0e<\/p>\n
 1            \u4f0a\u5e73\u5c4b\u6751       878 \n 2            \u5ea7\u9593\u5473\u6751       570 \n 3            \u5317\u5927\u6771\u6751       487 \n 4            \u6e21\u540d\u559c\u6751       219 \n 5            \u7c9f\u56fd\u6751         516 \n 6            \u6e21\u5609\u6577\u6751       641 \n 7            \u591a\u826f\u9593\u6751       738 \n 8            \u4f0a\u662f\u540d\u6751       1112 \n 9            \u5357\u5927\u6771\u6751       1039 \n 10           \u6771\u6751           1222 \n 11           \u4e0e\u90a3\u56fd\u753a       1421 \n 12           \u56fd\u982d\u6751         3011 \n 13           \u5927\u5b9c\u5473\u6751       2219 \n 14           \u4f0a\u6c5f\u6751         2418 \n 15           \u7af9\u5bcc\u753a         3752 \n 16           \u4e45\u7c73\u5cf6\u753a       4665 \n 17           \u4eca\u5e30\u4ec1\u6751       8825 \n 18           \u5b9c\u91ce\u5ea7\u6751       6495 \n 19           \u672c\u90e8\u753a         10812 \n 20           \u91d1\u6b66\u753a         11249 \n 21           \u6069\u7d0d\u6751         11926 \n 22           \u5609\u624b\u7d0d\u753a       12191 \n 23           \u5317\u4e2d\u57ce\u6751       16181 \n 24           \u4e0e\u90a3\u539f\u753a       18715 \n 25           \u4e2d\u57ce\u6751         25179 \n 26           \u5317\u8c37\u753a         29938 \n 27           \u897f\u539f\u753a         29299 \n 28           \u516b\u91cd\u702c\u753a       32308 \n 29           \u5bae\u53e4\u5cf6\u5e02       41289 \n 30           \u8aad\u8c37\u6751         40467 \n 31           \u5357\u98a8\u539f\u753a       42609 \n 32           \u5357\u57ce\u5e02         44923 \n 33           \u5b9c\u91ce\u6e7e\u5e02       102606 \n 34           \u77f3\u57a3\u5e02         45417 \n 35           \u7cf8\u6e80\u5e02         57254 \n 36           \u540d\u8b77\u5e02         61543 \n 37           \u8c4a\u898b\u57ce\u5e02       69660 \n 38           \u6d66\u6dfb\u5e02         117418 \n 39           \u3046\u308b\u307e\u5e02       117934 \n 40           \u6c96\u7e04\u5e02         148791 \n 41           \u90a3\u8987\u5e02         300368 <\/pre>\n
(6)-4 \u306f\u5931\u6557\u3059\u308b<\/h4>\n
\u3000\u5b9f\u884c\u6642\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u3057\u307e\u3046\uff0e<\/p>\n
\u7d50\u5c40\u30eb\u30fc\u30d7\u306a\u306e\u304b<\/h3>\n
\u3000\u3069\u3046\u306b\u3082\u3046\u307e\u304f\u884c\u304b\u306a\u3044\uff0e\u7d50\u5c40\uff0cCollection \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4ee3\u5165\u3057\u3066\u30bd\u30fc\u30c8\u3057\uff0c\u4e8c\u91cd\u30eb\u30fc\u30d7\u3067 SeriesCollection \u3068 Name \u30d7\u30ed\u30d1\u30c6\u30a3\u304c\u4e00\u81f4\u3057\u305f\u5834\u5408\u306b PlotOrder \u3092\u66f8\u304d\u63db\u3048\u308b\u3068\u3044\u3046\u65b9\u6cd5\u3057\u304b\u601d\u3044\u3064\u304b\u306a\u3044\uff0e<\/p>\n
For p = 1 To myColl.Count\n    myVar1 = myColl.Item(p).Values      'Values\/\/Series\/Variant()\n    myLong1 = myVar1(UBound(myVar1))    'Values(6)\/Long\n    'Debug.Print myLong1\n    For q = myColl.Count To p Step -1\n        myVar2 = myColl.Item(q).Values\n        myLong2 = myVar2(UBound(myVar2))\n        'Debug.Print , myLong2\n        If myLong1 > myLong2 Then\n            '(6)-1\n'           Stop\n            'Debug.Print myColl.Item(p).Name, myColl.Item(q).Name, ,\n            Set myColItemP = myColl.Item(p)\n            Set myColItemQ = myColl.Item(q)\n            myColl.Add myColItemQ, after:=p\n            myColl.Remove p\n            myColl.Add myColItemP, after:=q\n            myColl.Remove q\n            'Debug.Print myColl.Item(p).Name, myColl.Item(q).Name\n        End If\n    Next q\nNext p\n\nFor p = 1 To myColl.Count\n    'Debug.Print myColl.Item(p).Name,\n    'Debug.Print p, myColl.Item(p).PlotOrder, myColl.Item(p).Name\n    For q = 1 To .SeriesCollection.Count\n        If myColl.Item(p).Name = .SeriesCollection(q).Name Then\n            'Debug.Print .SeriesCollection(q).PlotOrder,\n            '(6)-6\n            .SeriesCollection(q).PlotOrder = myColl.Item(p).PlotOrder\n            '(6)-7\n            '.SeriesCollection(q).PlotOrder = p\n            'Debug.Print .SeriesCollection(q).PlotOrder\n        End If\n    Next q\n    Debug.Print p, myColl.Count, myColl.Item(p).PlotOrder, myColl.Item(p).Name\nNext p\n\nFor Each mySeries In .SeriesCollection\n'Debug.Print mySeries.PlotOrder, mySeries.Name, mySeries.Values(6)\nNext mySeries<\/pre>\n
\u3000\u3067\uff0c\u3084\u3063\u3066\u307f\u305f\uff0e<\/p>\n
(6)-6 \u306e\u7d50\u679c<\/h4>\n
 1             41            3            \u591a\u826f\u9593\u6751\n 2             41            6            \u4f0a\u662f\u540d\u6751\n 3             41            8            \u5317\u5927\u6771\u6751\n 4             41            5            \u4e45\u7c73\u5cf6\u753a\n 5             41            10           \u6e21\u540d\u559c\u6751\n 6             41            11           \u7c9f\u56fd\u6751\n 7             41            12           \u5ea7\u9593\u5473\u6751\n 8             41            13           \u6e21\u5609\u6577\u6751\n 9             41            7            \u4f0a\u5e73\u5c4b\u6751\n 10            41            9            \u5357\u5927\u6771\u6751\n 11            41            26           \u6771\u6751\n 12            41            1            \u4e0e\u90a3\u56fd\u753a\n 13            41            17           \u5317\u4e2d\u57ce\u6751\n 14            41            16           \u897f\u539f\u753a\n 15            41            27           \u5927\u5b9c\u5473\u6751\n 16            41            22           \u91d1\u6b66\u753a\n 17            41            24           \u672c\u90e8\u753a\n 18            41            21           \u4f0a\u6c5f\u6751\n 19            41            28           \u56fd\u982d\u6751\n 20            41            2            \u7af9\u5bcc\u753a\n 21            41            40           \u5b9c\u91ce\u5ea7\u6751\n 22            41            25           \u4eca\u5e30\u4ec1\u6751\n 23            41            23           \u6069\u7d0d\u6751\n 24            41            19           \u5609\u624b\u7d0d\u753a\n 25            41            15           \u4e0e\u90a3\u539f\u753a\n 26            41            41           \u4e2d\u57ce\u6751\n 27            41            18           \u5317\u8c37\u753a\n 28            41            4            \u516b\u91cd\u702c\u753a\n 29            41            20           \u8aad\u8c37\u6751\n 30            41            30           \u5bae\u53e4\u5cf6\u5e02\n 31            41            32           \u8c4a\u898b\u57ce\u5e02\n 32            41            37           \u77f3\u57a3\u5e02\n 33            41            35           \u540d\u8b77\u5e02\n 34            41            14           \u5357\u98a8\u539f\u753a\n 35            41            29           \u5357\u57ce\u5e02\n 36            41            34           \u7cf8\u6e80\u5e02\n 37            41            38           \u5b9c\u91ce\u6e7e\u5e02\n 38            41            36           \u6d66\u6dfb\u5e02\n 39            41            31           \u3046\u308b\u307e\u5e02\n 40            41            33           \u6c96\u7e04\u5e02\n 41            41            39           \u90a3\u8987\u5e02<\/pre>\n
(6)-7 \u306e\u7d50\u679c<\/h4>\n
 1             41            1            \u591a\u826f\u9593\u6751\n 2             41            2            \u4f0a\u662f\u540d\u6751\n 3             41            3            \u5317\u5927\u6771\u6751\n 4             41            4            \u4e45\u7c73\u5cf6\u753a\n 5             41            5            \u6e21\u540d\u559c\u6751\n 6             41            6            \u7c9f\u56fd\u6751\n 7             41            7            \u5ea7\u9593\u5473\u6751\n 8             41            8            \u6e21\u5609\u6577\u6751\n 9             41            9            \u4f0a\u5e73\u5c4b\u6751\n 10            41            10           \u5357\u5927\u6771\u6751\n 11            41            11           \u6771\u6751\n 12            41            12           \u4e0e\u90a3\u56fd\u753a\n 13            41            13           \u5317\u4e2d\u57ce\u6751\n 14            41            14           \u897f\u539f\u753a\n 15            41            15           \u5927\u5b9c\u5473\u6751\n 16            41            16           \u91d1\u6b66\u753a\n 17            41            17           \u672c\u90e8\u753a\n 18            41            18           \u4f0a\u6c5f\u6751\n 19            41            19           \u56fd\u982d\u6751\n 20            41            20           \u7af9\u5bcc\u753a\n 21            41            21           \u5b9c\u91ce\u5ea7\u6751\n 22            41            22           \u4eca\u5e30\u4ec1\u6751\n 23            41            23           \u6069\u7d0d\u6751\n 24            41            24           \u5609\u624b\u7d0d\u753a\n 25            41            25           \u4e0e\u90a3\u539f\u753a\n 26            41            26           \u4e2d\u57ce\u6751\n 27            41            27           \u5317\u8c37\u753a\n 28            41            28           \u516b\u91cd\u702c\u753a\n 29            41            29           \u8aad\u8c37\u6751\n 30            41            30           \u5bae\u53e4\u5cf6\u5e02\n 31            41            31           \u8c4a\u898b\u57ce\u5e02\n 32            41            32           \u77f3\u57a3\u5e02\n 33            41            33           \u540d\u8b77\u5e02\n 34            41            34           \u5357\u98a8\u539f\u753a\n 35            41            35           \u5357\u57ce\u5e02\n 36            41            36           \u7cf8\u6e80\u5e02\n 37            41            37           \u5b9c\u91ce\u6e7e\u5e02\n 38            41            38           \u6d66\u6dfb\u5e02\n 39            41            39           \u3046\u308b\u307e\u5e02\n 40            41            40           \u6c96\u7e04\u5e02\n 41            41            41           \u90a3\u8987\u5e02<\/pre>\n
\u3000\u7d50\u679c\u304c\u4e0d\u5b89\u5b9a\u3067\u3042\u308b\uff0e<\/p>\n
\u305d\u3082\u305d\u3082 Collection \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u6b63\u5e38\u306b\u683c\u7d0d\u3067\u304d\u3066\u3044\u308b\u306e\u3060\u308d\u3046\u304b\uff1f<\/h3>\n
\u3000\u30c6\u30b9\u30c8\u3057\u3066\u307f\u308b\u3057\u304b\u306a\u3044\uff0e<\/p>\n
Dim p           As Long\nDim myVar       As Variant\n\nFor Each mySeries In myCht.SeriesCollection\n    myColl.Add Item:=mySeries\nNext mySeries\n'(6)-8\nFor Each myVar In myColl\n    Debug.Print myVar.PlotOrder, myVar.Name,\n    myVar = myVar.Values\n    myVar = myVar(UBound(myVar))\n    Debug.Print myVar\nNext myVar\n'(6)-9\nFor p = 1 To myColl.Count\n    Debug.Print myColl.Item(p).PlotOrder, myColl.Item(p).Name,\n    myVar = myColl.Item(p).Values\n    myVar = myVar(UBound(myVar))\n    Debug.Print myVar\nNext p<\/pre>\n
For Each ~ Next \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u7d50\u679c<\/h4>\n
 1            \u4e0e\u90a3\u56fd\u753a       1421 \n 2            \u7af9\u5bcc\u753a         3752 \n 3            \u591a\u826f\u9593\u6751       738 \n 4            \u516b\u91cd\u702c\u753a       32308 \n 5            \u4e45\u7c73\u5cf6\u753a       4665 \n 6            \u4f0a\u662f\u540d\u6751       1112 \n 7            \u4f0a\u5e73\u5c4b\u6751       878 \n 8            \u5317\u5927\u6771\u6751       487 \n 9            \u5357\u5927\u6771\u6751       1039 \n 10           \u6e21\u540d\u559c\u6751       219 \n 11           \u7c9f\u56fd\u6751         516 \n 12           \u5ea7\u9593\u5473\u6751       570 \n 13           \u6e21\u5609\u6577\u6751       641 \n 14           \u5357\u98a8\u539f\u753a       42609 \n 15           \u4e0e\u90a3\u539f\u753a       18715 \n 16           \u897f\u539f\u753a         29299 \n 17           \u5317\u4e2d\u57ce\u6751       16181 \n 18           \u5317\u8c37\u753a         29938 \n 19           \u5609\u624b\u7d0d\u753a       12191 \n 20           \u8aad\u8c37\u6751         40467 \n 21           \u4f0a\u6c5f\u6751         2418 \n 22           \u91d1\u6b66\u753a         11249 \n 23           \u6069\u7d0d\u6751         11926 \n 24           \u672c\u90e8\u753a         10812 \n 25           \u4eca\u5e30\u4ec1\u6751       8825 \n 26           \u6771\u6751           1222 \n 27           \u5927\u5b9c\u5473\u6751       2219 \n 28           \u56fd\u982d\u6751         3011 \n 29           \u5357\u57ce\u5e02         44923 \n 30           \u5bae\u53e4\u5cf6\u5e02       41289 \n 31           \u3046\u308b\u307e\u5e02       117934 \n 32           \u8c4a\u898b\u57ce\u5e02       69660 \n 33           \u6c96\u7e04\u5e02         148791 \n 34           \u7cf8\u6e80\u5e02         57254 \n 35           \u540d\u8b77\u5e02         61543 \n 36           \u6d66\u6dfb\u5e02         117418 \n 37           \u77f3\u57a3\u5e02         45417 \n 38           \u5b9c\u91ce\u6e7e\u5e02       102606 \n 39           \u90a3\u8987\u5e02         300368 \n 40           \u5b9c\u91ce\u5ea7\u6751       6495 \n 41           \u4e2d\u57ce\u6751         25179 <\/pre>\n
For ~ Next \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u7d50\u679c<\/h4>\n
 1            \u4e0e\u90a3\u56fd\u753a       1421 \n 2            \u7af9\u5bcc\u753a         3752 \n 3            \u591a\u826f\u9593\u6751       738 \n 4            \u516b\u91cd\u702c\u753a       32308 \n 5            \u4e45\u7c73\u5cf6\u753a       4665 \n 6            \u4f0a\u662f\u540d\u6751       1112 \n 7            \u4f0a\u5e73\u5c4b\u6751       878 \n 8            \u5317\u5927\u6771\u6751       487 \n 9            \u5357\u5927\u6771\u6751       1039 \n 10           \u6e21\u540d\u559c\u6751       219 \n 11           \u7c9f\u56fd\u6751         516 \n 12           \u5ea7\u9593\u5473\u6751       570 \n 13           \u6e21\u5609\u6577\u6751       641 \n 14           \u5357\u98a8\u539f\u753a       42609 \n 15           \u4e0e\u90a3\u539f\u753a       18715 \n 16           \u897f\u539f\u753a         29299 \n 17           \u5317\u4e2d\u57ce\u6751       16181 \n 18           \u5317\u8c37\u753a         29938 \n 19           \u5609\u624b\u7d0d\u753a       12191 \n 20           \u8aad\u8c37\u6751         40467 \n 21           \u4f0a\u6c5f\u6751         2418 \n 22           \u91d1\u6b66\u753a         11249 \n 23           \u6069\u7d0d\u6751         11926 \n 24           \u672c\u90e8\u753a         10812 \n 25           \u4eca\u5e30\u4ec1\u6751       8825 \n 26           \u6771\u6751           1222 \n 27           \u5927\u5b9c\u5473\u6751       2219 \n 28           \u56fd\u982d\u6751         3011 \n 29           \u5357\u57ce\u5e02         44923 \n 30           \u5bae\u53e4\u5cf6\u5e02       41289 \n 31           \u3046\u308b\u307e\u5e02       117934 \n 32           \u8c4a\u898b\u57ce\u5e02       69660 \n 33           \u6c96\u7e04\u5e02         148791 \n 34           \u7cf8\u6e80\u5e02         57254 \n 35           \u540d\u8b77\u5e02         61543 \n 36           \u6d66\u6dfb\u5e02         117418 \n 37           \u77f3\u57a3\u5e02         45417 \n 38           \u5b9c\u91ce\u6e7e\u5e02       102606 \n 39           \u90a3\u8987\u5e02         300368 \n 40           \u5b9c\u91ce\u5ea7\u6751       6495 \n 41           \u4e2d\u57ce\u6751         25179 <\/pre>\n
Collection \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u306f\u6b63\u5e38\u306b\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b<\/h4>\n
\u3000\u3053\u308c\u306f\u304d\u3061\u3093\u3068\u53d6\u5f97\u3067\u304d\u3066\u3044\u308b\u3088\u3046\u3060\uff0e\u3068\u306a\u308b\u3068\uff0c\u30bd\u30fc\u30c8\u306b\u554f\u984c\u304c\u3042\u308b\u3053\u3068\u306b\u306a\u308b\uff0e<\/p>\n
\u8ab2\u984c<\/h3>\n
\u30002019 \u5e74 12 \u6708 25 \u65e5\u6642\u70b9\u3067 Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30bd\u30fc\u30c8\u306f\u89e3\u6c7a\u3067\u304d\u3066\u3044\u306a\u3044\uff0e2 \u9031\u9593\u307b\u3069\u7c98\u3063\u305f\u304c\uff0c\u99c4\u76ee\u3060\u3063\u305f\uff0e\u3053\u308c\u306f\u4eca\u5f8c\u306e\u8ab2\u984c\u3060\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3000Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092 PlotOrder \u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u30bd\u30fc\u30c8\u3059\u308b\u5fc5\u8981\u304c\u3042\u3063\u305f\u8a71\u3092\u3057\u305f\uff0e\u4eca\u56de\uff0cSeries \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u30bd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306b Collection \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u4ee3\u5165\u3057\u305f\u306e\u3060\u304c\uff0c\u914d\u5217\u306e\u6700\u7d42\u8981\u7d20\u3092\u53d6\u5f97 … <\/p>\n
“EXCEL VBA \u3067 Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u30bd\u30fc\u30c8\u3067\u304d\u306a\u304b\u3063\u305f\u8a71” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":9327,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[4580,4592,4612,5602,4566,4618,4567,4527,5814,5828,5804,5824,5805,4533,4997,265,5815,5825,4577,5818,5826,2474,4528,5813,5816,5622,4569,4548,4575,4534,5821,5820,5822,5827,4561,4585,4613,4657,5823,5415,5416,4995,5819,5809,5035,5817,459,4549,460,673,4516,5812,3575,4593,5811,5693,3553,4503,3949,4993,5810,1034,5806,5807,5829,4535,5830,4619],"class_list":{"0":"post-9299","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-technology","8":"tag-count","9":"tag-newseries","11":"tag-plotorder","12":"tag-values","14":"tag-xvalues","15":"tag-add","16":"tag-add-item","17":"tag-after","18":"tag-collection","19":"tag-collectionswap","21":"tag-debug","22":"tag-debug-print","23":"tag-excel","24":"tag-for-each","25":"tag-isobject","26":"tag-item","27":"tag-lbound","28":"tag-let","29":"tag-long","30":"tag-name","31":"tag-new","32":"tag-next","34":"tag-point","35":"tag-points","37":"tag-print","38":"tag-property-get","39":"tag-property-let","40":"tag-property-letproperty-get","41":"tag-remove","42":"tag-series","43":"tag-seriescollection","45":"tag-set","46":"tag-step","47":"tag-top","49":"tag-typename","50":"tag-ubound","51":"tag-variant","53":"tag-vartype","54":"tag-vba","55":"tag-4549","56":"tag-460","57":"tag-673","58":"tag-4516","59":"tag-5812","60":"tag-3575","61":"tag-4593","62":"tag-5811","63":"tag-5693","64":"tag-3553","65":"tag-4503","66":"tag-3949","67":"tag-4993","68":"tag-5810","69":"tag-1034","70":"tag-5806","71":"tag-5807","72":"tag-5829","73":"tag-4535","74":"tag-5830","75":"tag-4619"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/9299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9299"}],"version-history":[{"count":128,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/9299\/revisions"}],"predecessor-version":[{"id":9596,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/9299\/revisions\/9596"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/9327"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}