internal void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int totalCashNeededByBPNYearsRow, int simulationYearsCount) { stackedColumnChartCommon.SetWorksheetProperties(worksheet); var title = Properties.Resources.CashNeededByBPNUnconstrainedBudget; var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked); stackedColumnChartCommon.SetChartProperties(chart, title, 950, 700, 6, 7); SetChartAxes(chart); AddSeries(bridgeWorkSummaryWorkSheet, totalCashNeededByBPNYearsRow, simulationYearsCount, chart); chart.AdjustPositionAndSize(); chart.Locked = true; }
public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int totalBridgePostedCountByBPNYearsRow, int count) { stackedColumnChartCommon.SetWorksheetProperties(worksheet); var title = Properties.Resources.PostedBridgeCountByBPN; var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked); stackedColumnChartCommon.SetChartProperties(chart, title, 950, 700, 6, 7); stackedColumnChartCommon.SetChartAxes(chart); AddSeries(bridgeWorkSummaryWorkSheet, totalBridgePostedCountByBPNYearsRow, count, chart); chart.AdjustPositionAndSize(); chart.Locked = true; }
internal void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int totalPostedAndClosedByBPNYearsRow, int simulationYearsCount) { stackedColumnChartCommon.SetWorksheetProperties(worksheet); var title = Properties.Resources.CombinedPostedAndClosed; var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked); stackedColumnChartCommon.SetChartProperties(chart, title, 1200, 820, 2, 6); stackedColumnChartCommon.SetChartAxes(chart); AddSeries(bridgeWorkSummaryWorkSheet, totalPostedAndClosedByBPNYearsRow, simulationYearsCount, chart); //chart.AdjustPositionAndSize(); chart.Locked = true; }
public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int nonNHSDeckAreaPercentRow, int count) { stackedColumnChartCommon.SetWorksheetProperties(worksheet); var title = Properties.Resources.ConditionByDeckArea; var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked); stackedColumnChartCommon.SetChartProperties(chart, title, 950, 700, 6, 7); SetChartAxes(chart); AddSeries(bridgeWorkSummaryWorkSheet, nonNHSDeckAreaPercentRow, count, chart); chart.AdjustPositionAndSize(); chart.Locked = true; }