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