internal SLGroupDataLabelOptions Clone()
{
var gdlo = new SLGroupDataLabelOptions(ShapeProperties.listThemeColors);
gdlo.Rotation = Rotation;
gdlo.Vertical = Vertical;
gdlo.Anchor = Anchor;
gdlo.AnchorCenter = AnchorCenter;
gdlo.HasNumberingFormat = HasNumberingFormat;
gdlo.sFormatCode = sFormatCode;
gdlo.bSourceLinked = bSourceLinked;
gdlo.vLabelPosition = vLabelPosition;
gdlo.ShapeProperties = ShapeProperties.Clone();
gdlo.ShowLegendKey = ShowLegendKey;
gdlo.ShowValue = ShowValue;
gdlo.ShowCategoryName = ShowCategoryName;
gdlo.ShowSeriesName = ShowSeriesName;
gdlo.ShowPercentage = ShowPercentage;
gdlo.ShowBubbleSize = ShowBubbleSize;
gdlo.Separator = Separator;
gdlo.ShowLeaderLines = ShowLeaderLines;
return(gdlo);
}
internal C.PieChartSeries ToPieChartSeries(bool IsStylish = false)
{
var pcs = new C.PieChartSeries();
pcs.Index = new C.Index {
Val = Index
};
pcs.Order = new C.Order {
Val = Order
};
if (IsStringReference != null)
{
pcs.SeriesText = new C.SeriesText();
if (IsStringReference.Value)
{
pcs.SeriesText.StringReference = StringReference.ToStringReference();
}
else
{
pcs.SeriesText.NumericValue = new C.NumericValue(NumericValue);
}
}
if (Options.ShapeProperties.HasShapeProperties)
{
pcs.ChartShapeProperties = Options.ShapeProperties.ToChartShapeProperties(IsStylish);
}
if (Options.iExplosion != null)
{
pcs.Explosion = new C.Explosion {
Val = Options.Explosion
}
}
;
if (DataPointOptionsList.Count > 0)
{
var indexlist = DataPointOptionsList.Keys.ToList();
indexlist.Sort();
int index;
for (var i = 0; i < indexlist.Count; ++i)
{
index = indexlist[i];
pcs.Append(DataPointOptionsList[index].ToDataPoint(index, IsStylish));
}
}
if ((GroupDataLabelOptions != null) || (DataLabelOptionsList.Count > 0))
{
if (GroupDataLabelOptions == null)
{
var gdloptions = new SLGroupDataLabelOptions(new List <Color>());
pcs.Append(gdloptions.ToDataLabels(DataLabelOptionsList, true));
}
else
{
pcs.Append(GroupDataLabelOptions.ToDataLabels(DataLabelOptionsList, false));
}
}
pcs.Append(AxisData.ToCategoryAxisData());
pcs.Append(NumberData.ToValues());
return(pcs);
}
internal C.ScatterChartSeries ToScatterChartSeries(bool IsStylish = false)
{
var scs = new C.ScatterChartSeries();
scs.Index = new C.Index {
Val = Index
};
scs.Order = new C.Order {
Val = Order
};
if (IsStringReference != null)
{
scs.SeriesText = new C.SeriesText();
if (IsStringReference.Value)
{
scs.SeriesText.StringReference = StringReference.ToStringReference();
}
else
{
scs.SeriesText.NumericValue = new C.NumericValue(NumericValue);
}
}
if (Options.ShapeProperties.HasShapeProperties)
{
scs.ChartShapeProperties = Options.ShapeProperties.ToChartShapeProperties(IsStylish);
}
if (Options.Marker.HasMarker)
{
scs.Marker = Options.Marker.ToMarker(IsStylish);
}
if (DataPointOptionsList.Count > 0)
{
var indexlist = DataPointOptionsList.Keys.ToList();
indexlist.Sort();
int index;
for (var i = 0; i < indexlist.Count; ++i)
{
index = indexlist[i];
scs.Append(DataPointOptionsList[index].ToDataPoint(index, IsStylish));
}
}
if ((GroupDataLabelOptions != null) || (DataLabelOptionsList.Count > 0))
{
if (GroupDataLabelOptions == null)
{
var gdloptions = new SLGroupDataLabelOptions(new List <Color>());
scs.Append(gdloptions.ToDataLabels(DataLabelOptionsList, true));
}
else
{
scs.Append(GroupDataLabelOptions.ToDataLabels(DataLabelOptionsList, false));
}
}
scs.Append(AxisData.ToXValues());
scs.Append(NumberData.ToYValues());
scs.Append(new C.Smooth {
Val = Options.Smooth
});
return(scs);
}
internal C.BubbleChartSeries ToBubbleChartSeries(bool IsStylish = false)
{
var bcs = new C.BubbleChartSeries();
bcs.Index = new C.Index {
Val = Index
};
bcs.Order = new C.Order {
Val = Order
};
if (IsStringReference != null)
{
bcs.SeriesText = new C.SeriesText();
if (IsStringReference.Value)
{
bcs.SeriesText.StringReference = StringReference.ToStringReference();
}
else
{
bcs.SeriesText.NumericValue = new C.NumericValue(NumericValue);
}
}
if (Options.ShapeProperties.HasShapeProperties)
{
bcs.ChartShapeProperties = Options.ShapeProperties.ToChartShapeProperties(IsStylish);
}
bcs.InvertIfNegative = new C.InvertIfNegative {
Val = Options.InvertIfNegative ?? false
};
if (DataPointOptionsList.Count > 0)
{
var indexlist = DataPointOptionsList.Keys.ToList();
indexlist.Sort();
int index;
for (var i = 0; i < indexlist.Count; ++i)
{
index = indexlist[i];
bcs.Append(DataPointOptionsList[index].ToDataPoint(index, IsStylish));
}
}
if ((GroupDataLabelOptions != null) || (DataLabelOptionsList.Count > 0))
{
if (GroupDataLabelOptions == null)
{
var gdloptions = new SLGroupDataLabelOptions(new List <Color>());
bcs.Append(gdloptions.ToDataLabels(DataLabelOptionsList, true));
}
else
{
bcs.Append(GroupDataLabelOptions.ToDataLabels(DataLabelOptionsList, false));
}
}
bcs.Append(AxisData.ToXValues());
bcs.Append(NumberData.ToYValues());
bcs.Append(BubbleSize.ToBubbleSize());
if (Options.bBubble3D != null)
{
bcs.Append(new C.Bubble3D {
Val = Options.Bubble3D
});
}
return(bcs);
}
internal C.PlotArea ToPlotArea(bool IsStylish = false)
{
var pa = new C.PlotArea();
pa.Append(Layout.ToLayout());
int iChartType;
int i;
// TODO: the rendering order is sort of listed in the following.
// But apparently if you plot data series for doughnut first before bar-of-pie
// it's different than if you plot bar-of-pie then doughnut.
// Find out the "correct" order next version I suppose...
// Excel 2010 apparently sets this by default for any chart...
var gdlo = new SLGroupDataLabelOptions(ShapeProperties.listThemeColors);
gdlo.ShowLegendKey = false;
gdlo.ShowValue = false;
gdlo.ShowCategoryName = false;
gdlo.ShowSeriesName = false;
gdlo.ShowPercentage = false;
gdlo.ShowBubbleSize = false;
#region Doughnut
iChartType = (int)SLDataSeriesChartType.DoughnutChart;
if (UsedChartTypes[iChartType])
{
var dc = new C.DoughnutChart();
dc.VaryColors = new C.VaryColors {
Val = UsedChartOptions[iChartType].VaryColors ?? true
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
dc.Append(DataSeries[i].ToPieChartSeries(IsStylish));
}
}
dc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
dc.Append(new C.FirstSliceAngle {
Val = UsedChartOptions[iChartType].FirstSliceAngle
});
dc.Append(new C.HoleSize {
Val = UsedChartOptions[iChartType].HoleSize
});
pa.Append(dc);
}
#endregion
#region Bar-of-pie
iChartType = (int)SLDataSeriesChartType.OfPieChartBar;
if (UsedChartTypes[iChartType])
{
var opc = new C.OfPieChart();
opc.OfPieType = new C.OfPieType {
Val = C.OfPieValues.Bar
};
opc.VaryColors = new C.VaryColors {
Val = UsedChartOptions[iChartType].VaryColors ?? true
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
opc.Append(DataSeries[i].ToPieChartSeries(IsStylish));
}
}
opc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
opc.Append(new C.GapWidth {
Val = UsedChartOptions[iChartType].GapWidth
});
if (UsedChartOptions[iChartType].HasSplit)
{
opc.Append(new C.SplitType {
Val = UsedChartOptions[iChartType].SplitType
});
if (UsedChartOptions[iChartType].SplitType != C.SplitValues.Custom)
{
opc.Append(new C.SplitPosition {
Val = UsedChartOptions[iChartType].SplitPosition
});
}
else
{
var custsplit = new C.CustomSplit();
foreach (var iPiePoint in UsedChartOptions[iChartType].SecondPiePoints)
{
custsplit.Append(new C.SecondPiePoint {
Val = (uint)iPiePoint
});
}
opc.Append(custsplit);
}
}
opc.Append(new C.SecondPieSize {
Val = UsedChartOptions[iChartType].SecondPieSize
});
if (UsedChartOptions[iChartType].SeriesLinesShapeProperties.HasShapeProperties)
{
opc.Append(new C.SeriesLines
{
ChartShapeProperties =
UsedChartOptions[iChartType].SeriesLinesShapeProperties.ToChartShapeProperties()
});
}
else
{
opc.Append(new C.SeriesLines());
}
pa.Append(opc);
}
#endregion
#region Pie-of-pie
iChartType = (int)SLDataSeriesChartType.OfPieChartPie;
if (UsedChartTypes[iChartType])
{
var opc = new C.OfPieChart();
opc.OfPieType = new C.OfPieType {
Val = C.OfPieValues.Pie
};
opc.VaryColors = new C.VaryColors {
Val = UsedChartOptions[iChartType].VaryColors ?? true
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
opc.Append(DataSeries[i].ToPieChartSeries(IsStylish));
}
}
opc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
opc.Append(new C.GapWidth {
Val = UsedChartOptions[iChartType].GapWidth
});
if (UsedChartOptions[iChartType].HasSplit)
{
opc.Append(new C.SplitType {
Val = UsedChartOptions[iChartType].SplitType
});
if (UsedChartOptions[iChartType].SplitType != C.SplitValues.Custom)
{
opc.Append(new C.SplitPosition {
Val = UsedChartOptions[iChartType].SplitPosition
});
}
else
{
var custsplit = new C.CustomSplit();
foreach (var iPiePoint in UsedChartOptions[iChartType].SecondPiePoints)
{
custsplit.Append(new C.SecondPiePoint {
Val = (uint)iPiePoint
});
}
opc.Append(custsplit);
}
}
opc.Append(new C.SecondPieSize {
Val = UsedChartOptions[iChartType].SecondPieSize
});
if (UsedChartOptions[iChartType].SeriesLinesShapeProperties.HasShapeProperties)
{
opc.Append(new C.SeriesLines
{
ChartShapeProperties =
UsedChartOptions[iChartType].SeriesLinesShapeProperties.ToChartShapeProperties()
});
}
else
{
opc.Append(new C.SeriesLines());
}
pa.Append(opc);
}
#endregion
#region Pie
iChartType = (int)SLDataSeriesChartType.PieChart;
if (UsedChartTypes[iChartType])
{
var pc = new C.PieChart();
pc.VaryColors = new C.VaryColors {
Val = UsedChartOptions[iChartType].VaryColors ?? true
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
pc.Append(DataSeries[i].ToPieChartSeries(IsStylish));
}
}
pc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
pc.Append(new C.FirstSliceAngle {
Val = UsedChartOptions[iChartType].FirstSliceAngle
});
pa.Append(pc);
}
#endregion
#region Radar primary
iChartType = (int)SLDataSeriesChartType.RadarChartPrimary;
if (UsedChartTypes[iChartType])
{
var rc = new C.RadarChart();
rc.RadarStyle = new C.RadarStyle {
Val = UsedChartOptions[iChartType].RadarStyle
};
rc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
rc.Append(DataSeries[i].ToRadarChartSeries(IsStylish));
}
}
rc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
rc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
rc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
pa.Append(rc);
}
#endregion
#region Radar secondary
iChartType = (int)SLDataSeriesChartType.RadarChartSecondary;
if (UsedChartTypes[iChartType])
{
var rc = new C.RadarChart();
rc.RadarStyle = new C.RadarStyle {
Val = UsedChartOptions[iChartType].RadarStyle
};
rc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
rc.Append(DataSeries[i].ToRadarChartSeries(IsStylish));
}
}
rc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
rc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis1
});
rc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis2
});
pa.Append(rc);
}
#endregion
#region Area primary
iChartType = (int)SLDataSeriesChartType.AreaChartPrimary;
if (UsedChartTypes[iChartType])
{
var ac = new C.AreaChart();
ac.Grouping = new C.Grouping {
Val = UsedChartOptions[iChartType].Grouping
};
ac.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
ac.Append(DataSeries[i].ToAreaChartSeries(IsStylish));
}
}
ac.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
if (UsedChartOptions[iChartType].HasDropLines)
{
ac.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish));
}
ac.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
ac.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
pa.Append(ac);
}
#endregion
#region Area secondary
iChartType = (int)SLDataSeriesChartType.AreaChartSecondary;
if (UsedChartTypes[iChartType])
{
var ac = new C.AreaChart();
ac.Grouping = new C.Grouping {
Val = UsedChartOptions[iChartType].Grouping
};
ac.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
ac.Append(DataSeries[i].ToAreaChartSeries(IsStylish));
}
}
ac.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
if (UsedChartOptions[iChartType].HasDropLines)
{
ac.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish));
}
ac.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis1
});
ac.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis2
});
pa.Append(ac);
}
#endregion
#region Column primary
iChartType = (int)SLDataSeriesChartType.BarChartColumnPrimary;
if (UsedChartTypes[iChartType])
{
var bc = new C.BarChart();
bc.BarDirection = new C.BarDirection {
Val = C.BarDirectionValues.Column
};
bc.BarGrouping = new C.BarGrouping {
Val = UsedChartOptions[iChartType].BarGrouping
};
bc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
bc.Append(DataSeries[i].ToBarChartSeries(IsStylish));
}
}
bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
bc.Append(new C.GapWidth {
Val = UsedChartOptions[iChartType].GapWidth
});
if (UsedChartOptions[iChartType].Overlap != 0)
{
bc.Append(new C.Overlap {
Val = UsedChartOptions[iChartType].Overlap
});
}
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
pa.Append(bc);
}
#endregion
#region Column secondary
iChartType = (int)SLDataSeriesChartType.BarChartColumnSecondary;
if (UsedChartTypes[iChartType])
{
var bc = new C.BarChart();
bc.BarDirection = new C.BarDirection {
Val = C.BarDirectionValues.Column
};
bc.BarGrouping = new C.BarGrouping {
Val = UsedChartOptions[iChartType].BarGrouping
};
bc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
bc.Append(DataSeries[i].ToBarChartSeries(IsStylish));
}
}
bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
bc.Append(new C.GapWidth {
Val = UsedChartOptions[iChartType].GapWidth
});
if (UsedChartOptions[iChartType].Overlap != 0)
{
bc.Append(new C.Overlap {
Val = UsedChartOptions[iChartType].Overlap
});
}
bc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis1
});
bc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis2
});
pa.Append(bc);
}
#endregion
#region Bar primary
iChartType = (int)SLDataSeriesChartType.BarChartBarPrimary;
if (UsedChartTypes[iChartType])
{
var bc = new C.BarChart();
bc.BarDirection = new C.BarDirection {
Val = C.BarDirectionValues.Bar
};
bc.BarGrouping = new C.BarGrouping {
Val = UsedChartOptions[iChartType].BarGrouping
};
bc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
bc.Append(DataSeries[i].ToBarChartSeries(IsStylish));
}
}
bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
bc.Append(new C.GapWidth {
Val = UsedChartOptions[iChartType].GapWidth
});
if (UsedChartOptions[iChartType].Overlap != 0)
{
bc.Append(new C.Overlap {
Val = UsedChartOptions[iChartType].Overlap
});
}
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
pa.Append(bc);
}
#endregion
#region Bar secondary
iChartType = (int)SLDataSeriesChartType.BarChartBarSecondary;
if (UsedChartTypes[iChartType])
{
var bc = new C.BarChart();
bc.BarDirection = new C.BarDirection {
Val = C.BarDirectionValues.Bar
};
bc.BarGrouping = new C.BarGrouping {
Val = UsedChartOptions[iChartType].BarGrouping
};
bc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
bc.Append(DataSeries[i].ToBarChartSeries(IsStylish));
}
}
bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
bc.Append(new C.GapWidth {
Val = UsedChartOptions[iChartType].GapWidth
});
if (UsedChartOptions[iChartType].Overlap != 0)
{
bc.Append(new C.Overlap {
Val = UsedChartOptions[iChartType].Overlap
});
}
bc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis1
});
bc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis2
});
pa.Append(bc);
}
#endregion
#region Scatter primary
iChartType = (int)SLDataSeriesChartType.ScatterChartPrimary;
if (UsedChartTypes[iChartType])
{
var sc = new C.ScatterChart();
sc.ScatterStyle = new C.ScatterStyle {
Val = UsedChartOptions[iChartType].ScatterStyle
};
sc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
sc.Append(DataSeries[i].ToScatterChartSeries(IsStylish));
}
}
sc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
pa.Append(sc);
}
#endregion
#region Scatter secondary
iChartType = (int)SLDataSeriesChartType.ScatterChartSecondary;
if (UsedChartTypes[iChartType])
{
var sc = new C.ScatterChart();
sc.ScatterStyle = new C.ScatterStyle {
Val = UsedChartOptions[iChartType].ScatterStyle
};
sc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
sc.Append(DataSeries[i].ToScatterChartSeries(IsStylish));
}
}
sc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
sc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis1
});
sc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis2
});
pa.Append(sc);
}
#endregion
#region Line primary
iChartType = (int)SLDataSeriesChartType.LineChartPrimary;
if (UsedChartTypes[iChartType])
{
var lc = new C.LineChart();
lc.Grouping = new C.Grouping {
Val = UsedChartOptions[iChartType].Grouping
};
lc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
lc.Append(DataSeries[i].ToLineChartSeries(IsStylish));
}
}
lc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
if (UsedChartOptions[iChartType].HasDropLines)
{
lc.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish));
}
lc.Append(new C.ShowMarker {
Val = UsedChartOptions[iChartType].ShowMarker
});
lc.Append(new C.Smooth {
Val = UsedChartOptions[iChartType].Smooth
});
lc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
lc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
pa.Append(lc);
}
#endregion
#region Line secondary
iChartType = (int)SLDataSeriesChartType.LineChartSecondary;
if (UsedChartTypes[iChartType])
{
var lc = new C.LineChart();
lc.Grouping = new C.Grouping {
Val = UsedChartOptions[iChartType].Grouping
};
lc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
lc.Append(DataSeries[i].ToLineChartSeries(IsStylish));
}
}
lc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
if (UsedChartOptions[iChartType].HasDropLines)
{
lc.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish));
}
lc.Append(new C.ShowMarker {
Val = UsedChartOptions[iChartType].ShowMarker
});
lc.Append(new C.Smooth {
Val = UsedChartOptions[iChartType].Smooth
});
lc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis1
});
lc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis2
});
pa.Append(lc);
}
#endregion
#region Area3D
iChartType = (int)SLDataSeriesChartType.Area3DChart;
if (UsedChartTypes[iChartType])
{
var ac = new C.Area3DChart();
ac.Grouping = new C.Grouping {
Val = UsedChartOptions[iChartType].Grouping
};
ac.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
ac.Append(DataSeries[i].ToAreaChartSeries(IsStylish));
}
}
ac.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
if (UsedChartOptions[iChartType].GapDepth != 150)
{
ac.Append(new C.GapDepth {
Val = UsedChartOptions[iChartType].GapDepth
});
}
ac.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
ac.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
ac.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis3
});
pa.Append(ac);
}
#endregion
#region Bar3D
iChartType = (int)SLDataSeriesChartType.Bar3DChart;
if (UsedChartTypes[iChartType])
{
var bc = new C.Bar3DChart();
bc.BarDirection = new C.BarDirection {
Val = UsedChartOptions[iChartType].BarDirection
};
bc.BarGrouping = new C.BarGrouping {
Val = UsedChartOptions[iChartType].BarGrouping
};
bc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
bc.Append(DataSeries[i].ToBarChartSeries(IsStylish));
}
}
bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
bc.Append(new C.GapWidth {
Val = UsedChartOptions[iChartType].GapWidth
});
if (UsedChartOptions[iChartType].GapDepth != 150)
{
bc.Append(new C.GapDepth {
Val = UsedChartOptions[iChartType].GapDepth
});
}
bc.Append(new C.Shape {
Val = UsedChartOptions[iChartType].Shape
});
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis3
});
pa.Append(bc);
}
#endregion
#region Bubble
iChartType = (int)SLDataSeriesChartType.BubbleChart;
if (UsedChartTypes[iChartType])
{
var bc = new C.BubbleChart();
bc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
bc.Append(DataSeries[i].ToBubbleChartSeries(IsStylish));
}
}
bc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
if (!UsedChartOptions[iChartType].Bubble3D)
{
bc.Append(new C.Bubble3D {
Val = UsedChartOptions[iChartType].Bubble3D
});
}
if (UsedChartOptions[iChartType].BubbleScale != 100)
{
bc.Append(new C.BubbleScale {
Val = UsedChartOptions[iChartType].BubbleScale
});
}
if (!UsedChartOptions[iChartType].ShowNegativeBubbles)
{
bc.Append(new C.ShowNegativeBubbles {
Val = UsedChartOptions[iChartType].ShowNegativeBubbles
});
}
if (UsedChartOptions[iChartType].SizeRepresents != C.SizeRepresentsValues.Area)
{
bc.Append(new C.SizeRepresents {
Val = UsedChartOptions[iChartType].SizeRepresents
});
}
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
bc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
pa.Append(bc);
}
#endregion
#region Line3D
iChartType = (int)SLDataSeriesChartType.Line3DChart;
if (UsedChartTypes[iChartType])
{
var lc = new C.Line3DChart();
lc.Grouping = new C.Grouping {
Val = UsedChartOptions[iChartType].Grouping
};
lc.VaryColors = new C.VaryColors {
Val = false
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
lc.Append(DataSeries[i].ToLineChartSeries(IsStylish));
}
}
lc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
if (UsedChartOptions[iChartType].HasDropLines)
{
lc.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish));
}
if (UsedChartOptions[iChartType].GapDepth != 150)
{
lc.Append(new C.GapDepth {
Val = UsedChartOptions[iChartType].GapDepth
});
}
lc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
lc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
lc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis3
});
pa.Append(lc);
}
#endregion
#region Pie3D
iChartType = (int)SLDataSeriesChartType.Pie3DChart;
if (UsedChartTypes[iChartType])
{
var pc = new C.Pie3DChart();
pc.VaryColors = new C.VaryColors {
Val = UsedChartOptions[iChartType].VaryColors ?? true
};
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
pc.Append(DataSeries[i].ToPieChartSeries(IsStylish));
}
}
pc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
pa.Append(pc);
}
#endregion
#region Surface
iChartType = (int)SLDataSeriesChartType.SurfaceChart;
if (UsedChartTypes[iChartType])
{
var sc = new C.SurfaceChart();
if (UsedChartOptions[iChartType].bWireframe != null)
{
sc.Wireframe = new C.Wireframe {
Val = UsedChartOptions[iChartType].Wireframe
}
}
;
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
sc.Append(DataSeries[i].ToSurfaceChartSeries(IsStylish));
}
}
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis3
});
pa.Append(sc);
}
#endregion
#region Surface3D
iChartType = (int)SLDataSeriesChartType.Surface3DChart;
if (UsedChartTypes[iChartType])
{
var sc = new C.Surface3DChart();
if (UsedChartOptions[iChartType].bWireframe != null)
{
sc.Wireframe = new C.Wireframe {
Val = UsedChartOptions[iChartType].Wireframe
}
}
;
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
sc.Append(DataSeries[i].ToSurfaceChartSeries(IsStylish));
}
}
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis3
});
pa.Append(sc);
}
#endregion
#region Stock
iChartType = (int)SLDataSeriesChartType.StockChart;
if (UsedChartTypes[iChartType])
{
var sc = new C.StockChart();
for (i = 0; i < DataSeries.Count; ++i)
{
if ((int)DataSeries[i].ChartType == iChartType)
{
sc.Append(DataSeries[i].ToLineChartSeries(IsStylish));
}
}
sc.Append(gdlo.ToDataLabels(new Dictionary <int, SLDataLabelOptions>(), false));
if (UsedChartOptions[iChartType].HasDropLines)
{
sc.Append(UsedChartOptions[iChartType].DropLines.ToDropLines(IsStylish));
}
if (UsedChartOptions[iChartType].HasHighLowLines)
{
sc.Append(UsedChartOptions[iChartType].HighLowLines.ToHighLowLines(IsStylish));
}
if (UsedChartOptions[iChartType].HasUpDownBars)
{
sc.Append(UsedChartOptions[iChartType].UpDownBars.ToUpDownBars(IsStylish));
}
// stock charts either have a bar chart as the primary chart (the Volume) or doesn't.
// If there is, then it's either a Volume-High-Low-Close or Volumn-Open-High-Low-Close,
// so we use the secondary axis IDs.
if (UsedChartTypes[(int)SLDataSeriesChartType.BarChartColumnPrimary])
{
sc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis1
});
sc.Append(new C.AxisId {
Val = SLConstants.SecondaryAxis2
});
}
else
{
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis1
});
sc.Append(new C.AxisId {
Val = SLConstants.PrimaryAxis2
});
}
pa.Append(sc);
}
#endregion
if (HasPrimaryAxes)
{
PrimaryTextAxis.IsCrosses = PrimaryValueAxis.OtherAxisIsCrosses;
PrimaryTextAxis.Crosses = PrimaryValueAxis.OtherAxisCrosses;
PrimaryTextAxis.CrossesAt = PrimaryValueAxis.OtherAxisCrossesAt;
PrimaryTextAxis.OtherAxisIsInReverseOrder = PrimaryValueAxis.InReverseOrder;
if ((PrimaryValueAxis.OtherAxisIsCrosses != null) &&
PrimaryValueAxis.OtherAxisIsCrosses.Value &&
(PrimaryValueAxis.OtherAxisCrosses == C.CrossesValues.Maximum))
{
PrimaryTextAxis.OtherAxisCrossedAtMaximum = true;
}
else
{
PrimaryTextAxis.OtherAxisCrossedAtMaximum = false;
}
PrimaryValueAxis.IsCrosses = PrimaryTextAxis.OtherAxisIsCrosses;
PrimaryValueAxis.Crosses = PrimaryTextAxis.OtherAxisCrosses;
PrimaryValueAxis.CrossesAt = PrimaryTextAxis.OtherAxisCrossesAt;
PrimaryValueAxis.OtherAxisIsInReverseOrder = PrimaryTextAxis.InReverseOrder;
if ((PrimaryTextAxis.OtherAxisIsCrosses != null) &&
PrimaryTextAxis.OtherAxisIsCrosses.Value &&
(PrimaryTextAxis.OtherAxisCrosses == C.CrossesValues.Maximum))
{
PrimaryValueAxis.OtherAxisCrossedAtMaximum = true;
}
else
{
PrimaryValueAxis.OtherAxisCrossedAtMaximum = false;
}
switch (PrimaryTextAxis.AxisType)
{
case SLAxisType.Category:
pa.Append(PrimaryTextAxis.ToCategoryAxis(IsStylish));
break;
case SLAxisType.Date:
pa.Append(PrimaryTextAxis.ToDateAxis(IsStylish));
break;
case SLAxisType.Value:
pa.Append(PrimaryTextAxis.ToValueAxis(IsStylish));
break;
}
pa.Append(PrimaryValueAxis.ToValueAxis(IsStylish));
}
if (HasDepthAxis)
{
pa.Append(DepthAxis.ToSeriesAxis(IsStylish));
}
if (HasSecondaryAxes)
{
SecondaryTextAxis.IsCrosses = SecondaryValueAxis.OtherAxisIsCrosses;
SecondaryTextAxis.Crosses = SecondaryValueAxis.OtherAxisCrosses;
SecondaryTextAxis.CrossesAt = SecondaryValueAxis.OtherAxisCrossesAt;
SecondaryTextAxis.OtherAxisIsInReverseOrder = SecondaryValueAxis.InReverseOrder;
if ((SecondaryValueAxis.OtherAxisIsCrosses != null) &&
SecondaryValueAxis.OtherAxisIsCrosses.Value &&
(SecondaryValueAxis.OtherAxisCrosses == C.CrossesValues.Maximum))
{
SecondaryTextAxis.OtherAxisCrossedAtMaximum = true;
}
else
{
SecondaryTextAxis.OtherAxisCrossedAtMaximum = false;
}
SecondaryValueAxis.IsCrosses = SecondaryTextAxis.OtherAxisIsCrosses;
SecondaryValueAxis.Crosses = SecondaryTextAxis.OtherAxisCrosses;
SecondaryValueAxis.CrossesAt = SecondaryTextAxis.OtherAxisCrossesAt;
SecondaryValueAxis.OtherAxisIsInReverseOrder = SecondaryTextAxis.InReverseOrder;
if ((SecondaryTextAxis.OtherAxisIsCrosses != null) &&
SecondaryTextAxis.OtherAxisIsCrosses.Value &&
(SecondaryTextAxis.OtherAxisCrosses == C.CrossesValues.Maximum))
{
SecondaryValueAxis.OtherAxisCrossedAtMaximum = true;
}
else
{
SecondaryValueAxis.OtherAxisCrossedAtMaximum = false;
}
// the order of axes is:
// 1) primary category/date/value axis
// 2) primary value axis
// 3) secondary value axis
// 4) secondary category/date/value axis
pa.Append(SecondaryValueAxis.ToValueAxis(IsStylish));
switch (SecondaryTextAxis.AxisType)
{
case SLAxisType.Category:
pa.Append(SecondaryTextAxis.ToCategoryAxis(IsStylish));
break;
case SLAxisType.Date:
pa.Append(SecondaryTextAxis.ToDateAxis(IsStylish));
break;
case SLAxisType.Value:
pa.Append(SecondaryTextAxis.ToValueAxis(IsStylish));
break;
}
}
if (ShowDataTable)
{
pa.Append(DataTable.ToDataTable(IsStylish));
}
if (ShapeProperties.HasShapeProperties)
{
pa.Append(ShapeProperties.ToChartShapeProperties(IsStylish));
}
return(pa);
}