/// <summary> /// Fill NHS Condition Bridge Cnt and DA tab reports. /// </summary> /// <param name="worksheet"></param> /// <param name="bridgeWorkSummaryWorkSheet"></param> /// <param name="nhsPercentSectionYearsRow"></param> /// <param name="count"></param> public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int nhsPercentSectionYearsRow, string title, int count) { stackedColumnChartCommon.SetWorksheetProperties(worksheet); var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked); stackedColumnChartCommon.SetChartProperties(chart, title, 1050, 700, 6, 6); SetChartAxes(chart); AddSeries(bridgeWorkSummaryWorkSheet, nhsPercentSectionYearsRow, count, chart); chart.AdjustPositionAndSize(); chart.Locked = true; }
/// <summary> /// Fill Condition DA tab report /// </summary> /// <param name="worksheet"></param> /// <param name="bridgeWorkSummaryWorkSheet"></param> /// <param name="totalDeckAreaSectionYearsRow"></param> /// <param name="count"></param> public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int totalDeckAreaSectionYearsRow, int count) { stackedColumnChartCommon.SetWorksheetProperties(worksheet); var title = Properties.Resources.CombineNHSNonNHSConditionByDeckArea; var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked); stackedColumnChartCommon.SetChartProperties(chart, title, 950, 700, 6, 7); SetChartAxes(chart); AddSeries(bridgeWorkSummaryWorkSheet, totalDeckAreaSectionYearsRow, count, chart); chart.AdjustPositionAndSize(); chart.Locked = true; }
public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int totalPoorBridgesCountSectionYearsRow, int count) { stackedColumnChartCommon.SetWorksheetProperties(worksheet); var title = Properties.Resources.PoorBridgeCompareBridgeCount; var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked); stackedColumnChartCommon.SetChartProperties(chart, title, 1200, 820, 2, 6); stackedColumnChartCommon.SetChartAxes(chart); AddSeries(bridgeWorkSummaryWorkSheet, totalPoorBridgesCountSectionYearsRow, count, chart); //chart.AdjustPositionAndSize(); chart.Locked = true; }