| 23 | |
| 24 | |
| 25 | def draw_ordered_ranks(worksheet): |
| 26 | chart = LineChart() |
| 27 | chart.title = 'Ranks in descending order' |
| 28 | chart.x_axis.title = 'Function' |
| 29 | chart.y_axis.title = 'Rank' |
| 30 | chart.style = 11 |
| 31 | |
| 32 | i = 0 |
| 33 | while True: |
| 34 | a = alpha(worksheet, i) |
| 35 | if a is None: |
| 36 | break |
| 37 | col = 3 * i + 2 |
| 38 | data = Reference(worksheet, min_col=col, max_col=col, |
| 39 | min_row=2, max_row=min(worksheet.max_row, 100)) |
| 40 | series = Series(data, title='a=' + a) |
| 41 | series.smooth = True |
| 42 | series.graphicalProperties.line.width = 20000 |
| 43 | chart.append(series) |
| 44 | i += 1 |
| 45 | worksheet.add_chart(chart, 'D25') |
| 46 | |
| 47 | |
| 48 | def calc_stats(worksheet): |