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;
}
