How do you get the chart fill to be none in c#. I have tried Chart.PlotArea.Area.ForegroundColor = Color.Transparent and BackgroundColor. Neither seem to do anything See my code below
int chartIndex = sheet.Charts.Add(ChartType.Bar, 8, 12, rwcnt, 15);
Chart chart1 = sheet.Charts[chartIndex];
chart1.IsLegendShown = false;
chart1.PlotArea.Border.IsVisible = false;
chart1.NSeries.Add("AA" + rwcnt + ":AA9" , true);
chart1.PlotArea.Area.ForegroundColor = Color.Transparent;
chart1.ChartArea.Area.ForegroundColor = Color.Transparent;
chart1.ValueAxis.MajorGridLines.IsVisible = false;
chart1.ValueAxis.MinorGridLines.IsVisible = false;
chart1.CategoryAxis.IsPlotOrderReversed = true;