質問編集履歴

ソースコード編集

2022/01/08 02:40

投稿

epsilon

スコア2

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -56,17 +56,9 @@
 # x軸; 角度
-# y軸は
-#1; heat-O2
+# y軸は: heat-O2
-#2; thermo-C8H18
-#3; thermo-radius
-#4; O2-radius
-#5; C8H18-radiusの5種類
@@ -94,146 +86,20 @@
-  #heat-C8H18のグラフ作成(第1軸)
+  #第2軸に付け足すもの↓
-  chart_h_C8H18 = ScatterChart()
-  #chart_t.title = ""
-  chart_h_C8H18.x_axis.title = "Angular cordinate [deg.]  (from"+ str(temp_min) + "K to " + str(temp_max) + "K)"
-  chart_h_C8H18.y_axis.title = "Thermo diffusion [J/m^3/s]"
-  chart_h_C8H18.y_axis.scaling.logBase = 10
-  chart_h_C8H18.y_axis.numFmt = "0.00E+00"
-  chart_h_C8H18.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_h_C8H18.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_h_C8H18.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  chart_h_C8H18.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  #heat-radiusのグラフ作成(第1軸)
-  chart_h_r = ScatterChart()
-  #chart_t.title = ""
-  chart_h_r.x_axis.title = "Angular cordinate [deg.]"
-  chart_h_r.y_axis.title = "Thermo diffusion [J/m^3/s]"
-  chart_h_r.y_axis.scaling.logBase = 10
-  chart_h_r.y_axis.numFmt = "0.00E+00"
-  chart_h_r.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_h_r.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_h_r.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  chart_h_r.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  #C8H18-radiusのグラフ作成(第1軸)
-  chart_C8H18_r = ScatterChart()
-  #chart_C8H18_r.title = "O2拡散量"
-  chart_C8H18_r.x_axis.title = "Angular cordinate [deg.]"
-  chart_C8H18_r.y_axis.title = "C8H18 diffusion [kg/m^3/s]"
-  chart_C8H18_r.y_axis.numFmt = "0.00E+00"
-  chart_C8H18_r.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_C8H18_r.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_C8H18_r.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  chart_C8H18_r.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  #O2-radiusのグラフ作成(第1軸)
+  #O2のグラフ作成(第2軸)
-  chart_O2_r = ScatterChart()
+  chart_O2_2 = ScatterChart()
   #chart_C8H18.title = "O2拡散量"
-  chart_O2_r.x_axis.title = "Angular cordinate [deg.]"
-  chart_O2_r.y_axis.title = "O2 diffusion [kg/m^3/s]"
-  chart_O2_r.y_axis.numFmt = "0.00E+00"
-  chart_O2_r.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_O2_r.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_O2_r.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  chart_O2_r.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  #第2軸に付け足すもの↓
-  #radiusのグラフ作成(第2軸)
-  chart_r_2 = ScatterChart()
-  #chart_r.title = "熱拡散量"
-  chart_r_2.y_axis.title = "Flame radius [m]"
-  #chart_r_2.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_r_2.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  #chart_r_2.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  chart_r_2.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  #C8H18のグラフ作成(第2軸)
-  chart_C8H18_2 = ScatterChart()
-  #chart_C8H18_2.title = "C8H18拡散量"
-  #chart_C8H18_2.x_axis.title = "Angular cordinate [deg.]  (from"+ str(temp_min) + "K to " + str(temp_max) + "K)"
-  chart_C8H18_2.y_axis.title = "C8H18 diffusion [kg/m^3/s]"
-  chart_C8H18_2.y_axis.numFmt = "0.00E+00"
-  #chart_C8H18_2.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  chart_C8H18_2.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
-  #chart_C8H18_2.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  chart_C8H18_2.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
-  #O2のグラフ作成(第2軸)
-  chart_O2_2 = ScatterChart()
-  #chart_C8H18.title = "O2拡散量"
   #chart_O2.x_axis.title = "Angular cordinate [deg.]  (from"+ str(temp_min) + "K to " + str(temp_max) + "K)"
   chart_O2_2.y_axis.title = "O2 diffusion [kg/m^3/s]"
@@ -284,15 +150,13 @@
   # 系列のデータをSeriesオブジェクトとして定義する
-  series_r = Series(rvalues, agvalues, title = " Location from "+ str(temp_min) + "K to " + str(temp_max) + "K (Flame radius)" )
   series_h = Series(thermovalues, agvalues, title = "Thermo diffusion")
   series_O2 = Series(O2values, agvalues, title = "O2 diffusion" )
-  series_C8H18 = Series(C8H18values, agvalues, title = "C8H18 diffusion")
   serieslist = [series_r, series_h, series_O2, series_C8H18]
@@ -356,47 +220,25 @@
   chart_h_O2.series.append(series_h)
-  chart_h_C8H18.series.append(series_h)
-  chart_h_r.series.append(series_h)
-  chart_C8H18_r.series.append(series_C8H18)
-  chart_O2_r.series.append(series_O2)
   #第2軸となるグラフ
   chart_O2_2.series.append(series_O2)
-  chart_C8H18_2.series.append(series_C8H18)
-  chart_r_2.series.append(series_r)
   #第2軸のグラフを第1軸のグラフに合成
   chart_h_O2 += chart_O2_2
-  chart_h_C8H18 += chart_C8H18_2
-  chart_h_r += chart_r_2
-  chart_C8H18_r += chart_r_2
-  chart_O2_r += chart_r_2
-　#第1軸となるグラフのリスト
+　#第1軸となるグラフに凡例を追加
-  chartlist = [chart_h_O2, chart_h_C8H18, chart_h_r, chart_C8H18_r, chart_O2_r]
-  for chart in chartlist:
-   chart.legend.legendPos = "b"
+  chart_h_O2.legend.legendPos = "b"
@@ -414,15 +256,11 @@
-  ws.add_chart(chart_h_r, 'AH2')
-  ws.add_chart(chart_O2_r, 'AH20')
-  ws.add_chart(chart_C8H18_r, 'AH38')
-  ws.add_chart(chart_h_O2, 'AH56')
+  ws.add_chart(chart_h_O2, 'AH2')
-  ws.add_chart(chart_h_C8H18, 'AH74')

タグ追加

2022/01/08 02:40

投稿

epsilon

スコア2

test CHANGED Viewed

File without changes

test CHANGED Viewed

File without changes

補足

2021/12/30 05:16

投稿

epsilon

スコア2

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -36,6 +36,12 @@
+ここから横軸はタイトル１，縦軸にタイトル２，３のデータを使用して，
+グラフを作成したいと思っています。
 必要な設定など，何か分かる方いたらよろしくお願いします。

補足

2021/12/27 08:42

投稿

epsilon

スコア2

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -46,7 +46,21 @@
 ```python
+#生成されるグラフは
+# x軸; 角度
+# y軸は
+#1; heat-O2
+#2; thermo-C8H18
+#3; thermo-radius
+#4; O2-radius
+#5; C8H18-radiusの5種類

書式の改善

2021/12/23 08:50

投稿

epsilon

スコア2

test CHANGED Viewed

	@@ -1 +1 @@
1	- openpyxlを利用して，Excelで縦軸が2つあるグラフを作成したい
1	+ openpyxlを利用して，Excelで縦軸が2つあるグラフが作成できない

test CHANGED Viewed

@@ -1,9 +1,413 @@
+### 前提・実現したいこと
-python3.9でopenpyxlを利用して，縦軸が2つあるグラフを作成したいのですが，
+python3.9でopenpyxlを利用して，縦軸が2つある散布図グラフを作成したいと思っています．
+### 発生している問題・エラーメッセージ
+下のリンクを参考に書いても，エラーなどは無く動くのですが，
-下のリンクの通りに書いても，第2軸が来るはずの左側の縦軸が表示されない状態です。
+結果のグラフで，第2軸が来るはずの左側の縦軸が表示されない状態です。
 https://stackoverflow.com/questions/63696835/python-openpyxl-scatter-plots-with-secondary-y-axis
+生データは，1行目に項目名のタイトル，
+2行目以降にデータが行方向に並んだexcelファイルです
+タイトル1 タイトル2 タイトル3
+〇         △　　　　◆
+〇         △　　　　◆
+〇         △　　　　◆
+〇         △　　　　◆
 必要な設定など，何か分かる方いたらよろしくお願いします。
+### ソースコード
+```python
+  #heat-O2のグラフ作成(第1軸)
+  chart_h_O2 = ScatterChart()
+  #chart_t.title = ""
+  chart_h_O2.x_axis.title = "Angular cordinate [deg.]  (from"+ str(temp_min) + "K to " + str(temp_max) + "K)"
+  chart_h_O2.y_axis.title = "Thermo diffusion [J/m^3/s]"
+  chart_h_O2.y_axis.scaling.logBase = 10
+  chart_h_O2.y_axis.numFmt = "0.00E+00"
+  chart_h_O2.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_h_O2.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_h_O2.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  chart_h_O2.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  #heat-C8H18のグラフ作成(第1軸)
+  chart_h_C8H18 = ScatterChart()
+  #chart_t.title = ""
+  chart_h_C8H18.x_axis.title = "Angular cordinate [deg.]  (from"+ str(temp_min) + "K to " + str(temp_max) + "K)"
+  chart_h_C8H18.y_axis.title = "Thermo diffusion [J/m^3/s]"
+  chart_h_C8H18.y_axis.scaling.logBase = 10
+  chart_h_C8H18.y_axis.numFmt = "0.00E+00"
+  chart_h_C8H18.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_h_C8H18.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_h_C8H18.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  chart_h_C8H18.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  #heat-radiusのグラフ作成(第1軸)
+  chart_h_r = ScatterChart()
+  #chart_t.title = ""
+  chart_h_r.x_axis.title = "Angular cordinate [deg.]"
+  chart_h_r.y_axis.title = "Thermo diffusion [J/m^3/s]"
+  chart_h_r.y_axis.scaling.logBase = 10
+  chart_h_r.y_axis.numFmt = "0.00E+00"
+  chart_h_r.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_h_r.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_h_r.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  chart_h_r.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  #C8H18-radiusのグラフ作成(第1軸)
+  chart_C8H18_r = ScatterChart()
+  #chart_C8H18_r.title = "O2拡散量"
+  chart_C8H18_r.x_axis.title = "Angular cordinate [deg.]"
+  chart_C8H18_r.y_axis.title = "C8H18 diffusion [kg/m^3/s]"
+  chart_C8H18_r.y_axis.numFmt = "0.00E+00"
+  chart_C8H18_r.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_C8H18_r.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_C8H18_r.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  chart_C8H18_r.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  #O2-radiusのグラフ作成(第1軸)
+  chart_O2_r = ScatterChart()
+  #chart_C8H18.title = "O2拡散量"
+  chart_O2_r.x_axis.title = "Angular cordinate [deg.]"
+  chart_O2_r.y_axis.title = "O2 diffusion [kg/m^3/s]"
+  chart_O2_r.y_axis.numFmt = "0.00E+00"
+  chart_O2_r.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_O2_r.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_O2_r.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  chart_O2_r.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  #第2軸に付け足すもの↓
+  #radiusのグラフ作成(第2軸)
+  chart_r_2 = ScatterChart()
+  #chart_r.title = "熱拡散量"
+  chart_r_2.y_axis.title = "Flame radius [m]"
+  #chart_r_2.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_r_2.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  #chart_r_2.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  chart_r_2.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  #C8H18のグラフ作成(第2軸)
+  chart_C8H18_2 = ScatterChart()
+  #chart_C8H18_2.title = "C8H18拡散量"
+  #chart_C8H18_2.x_axis.title = "Angular cordinate [deg.]  (from"+ str(temp_min) + "K to " + str(temp_max) + "K)"
+  chart_C8H18_2.y_axis.title = "C8H18 diffusion [kg/m^3/s]"
+  chart_C8H18_2.y_axis.numFmt = "0.00E+00"
+  #chart_C8H18_2.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_C8H18_2.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  #chart_C8H18_2.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  chart_C8H18_2.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  #O2のグラフ作成(第2軸)
+  chart_O2_2 = ScatterChart()
+  #chart_C8H18.title = "O2拡散量"
+  #chart_O2.x_axis.title = "Angular cordinate [deg.]  (from"+ str(temp_min) + "K to " + str(temp_max) + "K)"
+  chart_O2_2.y_axis.title = "O2 diffusion [kg/m^3/s]"
+  chart_O2_2.y_axis.numFmt = "0.00E+00"
+  #chart_O2.x_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  chart_O2_2.y_axis.spPr = GraphicalProperties(ln =LineProperties(solidFill="E6E6E6", w=1*12700))
+  #chart_O2.x_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  chart_O2_2.y_axis.majorGridlines.spPr = GraphicalProperties(ln=LineProperties(solidFill= "E6E6E6", w=0.01*12700))
+  # 凡例の配置位置
+  #chart1.legend.position = 'b'
+  #r,l,t,b and tr for right, left, top, bottom and top right. default is right.
+  nrow=ws.max_row
+  ncol=ws.max_column
+  # 系列のY軸の値の参照する
+  rvalues = Reference(ws, min_col=r+1, max_col=r+1, min_row=2, max_row=73)
+  thermovalues = Reference(ws, min_col=h+1, max_col=h+1, min_row=2, max_row=73)
+  O2values = Reference(ws, min_col=O2+1, max_col=O2+1, min_row=2, max_row=73)
+  C8H18values = Reference(ws, min_col=C8H18+1, max_col=C8H18+1, min_row=2, max_row=73)
+  # 系列のX軸の値の参照する
+  agvalues = Reference(ws, min_col=ag+1, max_col=ag+1, min_row=2, max_row=73)
+  # 系列のデータをSeriesオブジェクトとして定義する
+  series_r = Series(rvalues, agvalues, title = " Location from "+ str(temp_min) + "K to " + str(temp_max) + "K (Flame radius)" )
+  series_h = Series(thermovalues, agvalues, title = "Thermo diffusion")
+  series_O2 = Series(O2values, agvalues, title = "O2 diffusion" )
+  series_C8H18 = Series(C8H18values, agvalues, title = "C8H18 diffusion")
+  serieslist = [series_r, series_h, series_O2, series_C8H18]
+  # 各系列のプロットを表現するマーカーのシンボルの指定を辞書形式で用意
+  #marker_symbol = {1:"triangle", 2:"diamond", 3:"square", 4:"star", 5:"circle", 6:"plus"}
+  # マーカーを塗り潰す色を同様に辞書形式で用意
+  # 色の指定はRGBのHex指定とColorChoiceオブジェクト指定による2タイプで指定
+  #marker_solidFill = {1:"00bFFF", 2:"FF4500", 3:"FFF0F",
+                       # 4:ColorChoice(prstClr="midnightBlue"),
+                       # 5:ColorChoice(prstClr="yellowGreen"),
+                       # 6:ColorChoice(prstClr="cornflowerBlue")}
+  #各系列のマーカーの形状,色を指定
+  marker_solidFill = {1:"4169e1", 2:"ffc0cb", 3:"90ee90", 4:"90ee90"}
+  marker_linesolidFill = {1:"191970", 2:"ff4500", 3:"228b22", 4:"228b22"}
+  for i, obj in enumerate(serieslist, 1):
+    # ラインの設定
+    #obj.graphicalProperties.line.noFill = True
+    obj.spPr.ln.solidFill = marker_linesolidFill[i]
+    # 以下マーカーの設定
+    obj.marker.symbol = "circle" # シンボルを指定
+    obj.marker.size = 5                # サイズを指定
+    obj.marker.graphicalProperties.solidFill = marker_solidFill[i]  # 塗りつぶし色
+    obj.marker.graphicalProperties.line.solidFill = marker_linesolidFill[i]  # 枠線色
+  #各系列をグラフに追加
+  #第1軸となるグラフ
+  chart_h_O2.series.append(series_h)
+  chart_h_C8H18.series.append(series_h)
+  chart_h_r.series.append(series_h)
+  chart_C8H18_r.series.append(series_C8H18)
+  chart_O2_r.series.append(series_O2)
+  #第2軸となるグラフ
+  chart_O2_2.series.append(series_O2)
+  chart_C8H18_2.series.append(series_C8H18)
+  chart_r_2.series.append(series_r)
+  #第2軸のグラフを第1軸のグラフに合成
+  chart_h_O2 += chart_O2_2
+  chart_h_C8H18 += chart_C8H18_2
+  chart_h_r += chart_r_2
+  chart_C8H18_r += chart_r_2
+  chart_O2_r += chart_r_2
+　#第1軸となるグラフのリスト
+  chartlist = [chart_h_O2, chart_h_C8H18, chart_h_r, chart_C8H18_r, chart_O2_r]
+  for chart in chartlist:
+   chart.legend.legendPos = "b"
+  #第2軸となるグラフのリスト
+  chartlist2 = [chart_O2_2, chart_C8H18_2, chart_r_2]
+  for chart in chartlist2:
+  #自分のソースコードでは，第2軸が右に来るようにしています．
+　chart.y_axis.crosses = "max"
+  ws.add_chart(chart_h_r, 'AH2')
+  ws.add_chart(chart_O2_r, 'AH20')
+  ws.add_chart(chart_C8H18_r, 'AH38')
+  ws.add_chart(chart_h_O2, 'AH56')
+  ws.add_chart(chart_h_C8H18, 'AH74')
+ wb.save(file)
+ wb.close
+```