def fxGraph():
global fxChart
title = "FX Prices"
yLabel = "USD"
names = [fxSheet.B1,fxSheet.C1,fxSheet.D1]
startRow = getForecastStartRow()
endRow = getForecastEndRow()
times = []
for row in fxSheet.Rows[2:]:
times.Add(str(row[1]))
USDValues = [[],[],[]]
for row in fxSheet.Rows[2:]:
USDValues[0].Add(row[2])
USDValues[1].Add(row[3])
USDValues[2].Add(row[4])
fxChart = rslWPFChart(title, yLabel, names, times, USDValues)
fxChart.Start()
def commodGraph():
global commodChart
title = "Commodity Prices"
yLabel = "USD"
names = [commoditySheet.B1,commoditySheet.C1,commoditySheet.D1]
startRow = getForecastStartRow()
endRow = getForecastEndRow()
times = []
for row in commoditySheet.Rows[2:]:
times.Add(str(row[1]))
USDValues = [[],[],[]]
for row in commoditySheet.Rows[2:]:
USDValues[0].Add(row[2])
USDValues[1].Add(row[3])
USDValues[2].Add(row[4])
commodChart = rslWPFChart(title, yLabel, names, times, USDValues)
commodChart.Start()