1

I want to set individual bar color of bar chart in excel using epplus. Please see the below code.

ExcelWorksheet wsGraph = pck.Workbook.Worksheets.Add("Graph");
wsGraph.Cells["D2"].LoadFromDataTable(dtGraph, true);
ExcelBarChart chat =(ExcelBarChart) wsGraph.Drawings.AddChart("Status", eChartType.BarClustered);
chat.Title.Text= "Tickets Status";
chat.SetPosition(1, 0, 3, 0);
chat.SetSize(500, 300);
chat.Series.Add(wsGraph.Cells["E3:E8"], wsGraph.Cells["D3:D8"]);

I want to this type chart.Also set series gap and bar height and width.

I need this type of graph Above code showing this graph

Ernie S
  • 13,902
  • 4
  • 52
  • 79
Sumit Manna
  • 541
  • 1
  • 5
  • 16
  • Here I show how to set colors of individual elements of the different bars of the chart: http://stackoverflow.com/questions/34356874/epplus-columnstacked-chart-data-point-colors/34403425#34403425 – Ernie S Apr 07 '17 at 12:12

0 Answers0