How to vary colors by point in .NET Excel Library

14 Aug 20261 minute to read

The following code snippet shows how to vary colors by point for a line chart series.

chart.Series[0].SerieFormat.LineProperties.AutoFormat = true;
chart.Series[0].SerieFormat.CommonSerieOptions.IsVaryColor = true;
chart.Series[0].SerieFormat.LineProperties.AutoFormat = true;
chart.Series[0].SerieFormat.CommonSerieOptions.IsVaryColor = true;
chart.Series[0].SerieFormat.LineProperties.AutoFormat = True
chart.Series[0].SerieFormat.CommonSerieOptions.IsVaryColor = True

The following code snippet shows how to vary colors by point for a column chart series.

chart.Series[0].SerieFormat.Interior.UseAutomaticFormat = true;
chart.Series[0].SerieFormat.CommonSerieOptions.IsVaryColor = true;
chart.Series[0].SerieFormat.Interior.UseAutomaticFormat = true;
chart.Series[0].SerieFormat.CommonSerieOptions.IsVaryColor = true;
chart.Series[0].SerieFormat.Interior.UseAutomaticFormat = True
chart.Series[0].SerieFormat.CommonSerieOptions.IsVaryColor = True