private void SetChartAxes(ExcelChart chart)
{
stackedColumnChartCommon.SetChartAxes(chart);
var yAxis = chart.YAxis;
yAxis.Format = "_(* #,##0.00_);_(* (#,##0.00);_(* -??_);_(@_)";
}
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";
}
/// <summary>
/// Fill Condition Bridge Cnt tab report.
/// </summary>
/// <param name="worksheet"></param>
/// <param name="bridgeWorkSummaryWorkSheet"></param>
/// <param name="totalBridgeCountSectionYearsRow"></param>
/// <param name="count"></param>
public void Fill(ExcelWorksheet worksheet, ExcelWorksheet bridgeWorkSummaryWorkSheet, int totalBridgeCountSectionYearsRow, int count)
{
stackedColumnChartCommon.SetWorksheetProperties(worksheet);
var title = Properties.Resources.ConditionByBridgeCount;
var chart = worksheet.Drawings.AddChart(title, eChartType.ColumnStacked);
stackedColumnChartCommon.SetChartProperties(chart, title, 950, 700, 6, 7);
stackedColumnChartCommon.SetChartAxes(chart);
AddSeries(bridgeWorkSummaryWorkSheet, totalBridgeCountSectionYearsRow, count, chart);
chart.AdjustPositionAndSize();
chart.Locked = true;
}
private void SetChartAxes(ExcelChart chart)
{
stackedColumnChartCommon.SetChartAxes(chart);
chart.YAxis.Format = "#0%";
chart.YAxis.MaxValue = 1;
}
