def generateHealthTrendGraph(weeklyTrendSheet, graphSheet):
print("Drawing Overall graph")
chart_health_overall = BarChart()
chart_health_overall.type = "col"
chart_health_overall.name = " Overall Health Trend"
#chart_health_overall.style = 13
chart_health_overall.title = "Overall Health Trend"
chart_health_overall.y_axis.title = 'System Area'
chart_health_overall.x_axis.title = 'WeeklyProgress'
data = Reference(weeklyTrendSheet,
min_col=2,
min_row=2,
max_row=15,
max_col=3)
cats = Reference(weeklyTrendSheet, min_col=1, min_row=2, max_row=15)
chart_health_overall.add_data(data, titles_from_data=True)
chart_health_overall.set_categories(cats)
#chart_health_overall.shape = 30
graphSheet.add_chart(chart_health_overall, "B2")
# For Security
print("Drawing Security graph")
chart_health_Security = BarChart()
chart_health_Security.type = "col"
chart_health_Security.name = " Security Area Trends"
#chart_health_Security.style = 13
chart_health_Security.title = "Security Area Trend"
chart_health_Security.y_axis.title = 'Security Area'
chart_health_Security.x_axis.title = 'WeeklyProgress'
data = Reference(weeklyTrendSheet,
min_col=6,
min_row=2,
max_row=15,
max_col=6)
cats = Reference(weeklyTrendSheet, min_col=1, min_row=2, max_row=15)
chart_health_Security.add_data(data, titles_from_data=True)
chart_health_Security.set_categories(cats)
#chart_health_Security.shape = 30
graphSheet.add_chart(chart_health_Security, "M2")
# For Serviceability
print("Drawing Serviceability graph")
chart_health_Serviceability = BarChart()
chart_health_Serviceability.type = "col"
chart_health_Serviceability.name = " Serviceability Area Trends"
# chart_health_Serviceability.style = 13
chart_health_Serviceability.title = "Serviceability Area Trend"
chart_health_Serviceability.y_axis.title = 'Serviceability Area'
chart_health_Serviceability.x_axis.title = 'WeeklyProgress'
data = Reference(weeklyTrendSheet,
min_col=5,
min_row=2,
max_row=15,
max_col=5)
cats = Reference(weeklyTrendSheet, min_col=1, min_row=2, max_row=15)
chart_health_Serviceability.add_data(data, titles_from_data=True)
chart_health_Serviceability.set_categories(cats)
# chart_health_Serviceability.shape = 30
graphSheet.add_chart(chart_health_Serviceability, "B20")
# For 5G
print("Drawing 5G graph")
chart_health_5G = BarChart()
chart_health_5G.type = "col"
chart_health_5G.name = " 5G Area Trends"
# chart_health_5G.style = 13
chart_health_5G.title = "5G Area Trend"
chart_health_5G.y_axis.title = '5G Area'
chart_health_5G.x_axis.title = 'WeeklyProgress'
data = Reference(weeklyTrendSheet,
min_col=9,
min_row=2,
max_row=15,
max_col=9)
cats = Reference(weeklyTrendSheet, min_col=1, min_row=2, max_row=15)
chart_health_5G.add_data(data, titles_from_data=True)
chart_health_5G.set_categories(cats)
# chart_health_5G.shape = 30
graphSheet.add_chart(chart_health_5G, "B60")
# For RET&MAV
print("Drawing RET&MAV graph")
chart_health_RETMAV = BarChart()
chart_health_RETMAV.type = "col"
chart_health_RETMAV.name = " RET&MAV Area Trends"
# chart_health_RETMAV.style = 13
chart_health_RETMAV.title = "RET&MAV Area Trend"
chart_health_RETMAV.y_axis.title = 'RET&MAV Area'
chart_health_RETMAV.x_axis.title = 'WeeklyProgress'
data = Reference(weeklyTrendSheet,
min_col=7,
min_row=2,
max_row=15,
max_col=7)
cats = Reference(weeklyTrendSheet, min_col=1, min_row=2, max_row=15)
chart_health_RETMAV.add_data(data, titles_from_data=True)
chart_health_RETMAV.set_categories(cats)
# chart_health_RETMAV.shape = 30
graphSheet.add_chart(chart_health_RETMAV, "B40")
# For NetAct
print("Drawing NetAct graph")
chart_health_NETACT = BarChart()
chart_health_NETACT.type = "col"
chart_health_NETACT.name = " NetAct Area Trends"
# chart_health_NETACT.style = 13
chart_health_NETACT.title = "NetAct Area Trend"
chart_health_NETACT.y_axis.title = 'NetAct Area'
chart_health_NETACT.x_axis.title = 'WeeklyProgress'
data = Reference(weeklyTrendSheet,
min_col=8,
min_row=2,
max_row=15,
max_col=8)
cats = Reference(weeklyTrendSheet, min_col=1, min_row=2, max_row=15)
chart_health_NETACT.add_data(data, titles_from_data=True)
chart_health_NETACT.set_categories(cats)
# chart_health_NETACT.shape = 30
graphSheet.add_chart(chart_health_NETACT, "M40")
# For Performance
print("Drawing Performance graph")
chart_health_Perf = BarChart()
chart_health_Perf.type = "col"
chart_health_Perf.name = " Performance Area Trends"
# chart_health_Perf.style = 13
chart_health_Perf.title = "Performance Area Trend"
chart_health_Perf.y_axis.title = 'Performance Area'
chart_health_Perf.x_axis.title = 'WeeklyProgress'
data = Reference(weeklyTrendSheet,
min_col=4,
min_row=2,
max_row=15,
max_col=4)
cats = Reference(weeklyTrendSheet, min_col=1, min_row=2, max_row=15)
chart_health_Perf.add_data(data, titles_from_data=True)
chart_health_Perf.set_categories(cats)
# chart_health_Perf.shape = 30
graphSheet.add_chart(chart_health_Perf, "M20")
