I’m using a designer file for my chart. It’s a very simple chart. When I look at the designer file, it looks great. After I add the data, it moves the left axis over about an inch so now it’s inside the chart. I looked at the axis settings and it says that the axis should be on the left. I can email examples if it will help.
Here’s the code:
private void CreateChart(Excel excel)
//use gets 12 weeks of data on chart for each workgroup selected.
{
string designerFile = System.Configuration.ConfigurationSettings.AppSettings.Get(“AsposeFile”);
excel.Open(designerChartFile);
this.dataTbl.Reset();
this.oleDbComm = this.oleDbConn.CreateCommand();
this.oleDbComm.CommandType = CommandType.StoredProcedure;
this.oleDbComm.CommandText = “p_sel_CASH_LOG_RPT_ITEMS_WKGP”;
//ONE PARAMETER, WORKGROUP TYPE SEQ NUM
this.oleDbComm.Parameters.Add(new OleDbParameter("@WORKGROUP",OleDbType.Integer));
oleDbComm.Parameters["@WORKGROUP"].Value = System.Convert.ToInt32(lstWorkgroup.SelectedValue);
this.oleDbAdapter = new OleDbDataAdapter(this.oleDbComm);
this.oleDbAdapter.Fill(this.dataTbl);
Worksheet sheet = excel.Worksheets[“Compliance Chart”];
sheet.Name = “Compliance Chart1”;
Cells cells = sheet.Cells;
sheet.Cells.ImportDataTable(this.dataTbl, false, 20,0);
//Here’s where I add the data…
for(int i = 21; i < 34; i++) //This holds the 12 rows for the dates
{
cells[i-1,2].Formula="=(D33-D" + i + “)/D33”;
}
cells[32,3].Formula="=SUM(D21:D32)";
excel.Save(“ComplianceChart.xls”, SaveType.OpenInExcel, FileFormatType.Excel2000, Response);
}
Thank you,
Terri
Hi Terri,
Could you send me your designer file? That will help me investigate this problem. Thanks.