public static void Run()
{
//ExStart:SupportForSwitchingRowsAndColumns
string dataDir = RunExamples.GetDataDir_Charts();
using (Presentation pres = new Presentation(dataDir + "Test.pptx"))
{
IChart chart = pres.Slides[0].Shapes.AddChart(ChartType.ClusteredColumn, 100, 100, 400, 300);
IChartSeries[] series = new IChartSeries[chart.ChartData.Series.Count];
chart.ChartData.Series.CopyTo(series, 0);
IChartDataCell[] categoriesCells = new IChartDataCell[chart.ChartData.Categories.Count];
for (int i = 0; i < chart.ChartData.Categories.Count; i++)
{
categoriesCells[i] = chart.ChartData.Categories[i].AsCell;
}
IChartDataCell[] seriesCells = new IChartDataCell[chart.ChartData.Series.Count];
for (int i = 0; i < chart.ChartData.Series.Count; i++)
{
seriesCells[i] = chart.ChartData.Series[i].Name.AsCells[0];
}
chart.ChartData.SwitchRowColumn();
pres.Save(RunExamples.OutPath + "Test_out.pptx", SaveFormat.Pptx);
//ExEnd:SupportForSwitchingRowsAndColumns
}
}
public static void Run()
{
string outpptxFile = Path.Combine(RunExamples.OutPath, "ChartDataCell_Formulas_out.pptx");
using (Presentation presentation = new Presentation())
{
IChart chart = presentation.Slides[0].Shapes.AddChart(ChartType.ClusteredColumn, 150, 150, 500, 300);
IChartDataWorkbook workbook = chart.ChartData.ChartDataWorkbook;
IChartDataCell cell1 = workbook.GetCell(0, "B2");
cell1.Formula = "1 + SUM(F2:H5)";
IChartDataCell cell2 = workbook.GetCell(0, "C2");
cell2.R1C1Formula = "MAX(R2C6:R5C8) / 3";
presentation.Save(outpptxFile, SaveFormat.Pptx);
}
}
public static void Run()
{
//ExStart:SwitchChartRowColumns
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir_Charts();
// Creating empty presentation
using (Presentation pres = new Presentation())
{
IChart chart = pres.Slides[0].Shapes.AddChart(ChartType.ClusteredColumn, 100, 100, 400, 300);
//Add data
IChartSeries[] series = new IChartSeries[chart.ChartData.Series.Count];
chart.ChartData.Series.CopyTo(series, 0);
IChartDataCell[] categoriesCells = new IChartDataCell[chart.ChartData.Categories.Count];
for (int i = 0; i < chart.ChartData.Categories.Count; i++)
{
categoriesCells[i] = chart.ChartData.Categories[i].AsCell;
}
IChartDataCell[] seriesCells = new IChartDataCell[chart.ChartData.Series.Count];
for (int i = 0; i < chart.ChartData.Series.Count; i++)
{
seriesCells[i] = chart.ChartData.Series[i].Name.AsCells[0];
}
//Switching rows and columns
chart.ChartData.SwitchRowColumn();
// Saving presentation
pres.Save(RunExamples.OutPath + "SwitchChartRowColumns_out.pptx", SaveFormat.Pptx);
//ExEnd:SwitchChartRowColumns
}
}
