private void SetChartAxes(ExcelChart chart)
{
stackedColumnChartCommon.SetChartAxes(chart);
var yAxis = chart.YAxis;
yAxis.DisplayUnit = 1000000;
yAxis.Format = "_-$* #,##0.00_-;-$* #,##0.00_-;_-$* \"-\"??_-;_-@_-";
yAxis.Title.TextVertical = OfficeOpenXml.Drawing.eTextVerticalType.Vertical;
yAxis.Title.Font.Size = 10;
yAxis.Title.Text = "Millions ($)";
}
private void SetChartAxes(ExcelChart chart)
{
stackedColumnChartCommon.SetChartAxes(chart);
var yAxis = chart.YAxis;
yAxis.DisplayUnit = 1000000;
yAxis.Format = "_(* #,##0.00_);_(* (#,##0.00);_(* -??_);_(@_)";
yAxis.Title.TextVertical = OfficeOpenXml.Drawing.eTextVerticalType.Vertical;
yAxis.Title.Font.Size = 10;
yAxis.Title.Text = "Millions sqft";
}
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 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;
}
private void SetChartAxes(ExcelChart chart)
{
stackedColumnChartCommon.SetChartAxes(chart);
chart.YAxis.Format = "#0%";
chart.YAxis.MaxValue = 1;
}
