Hi again,
Please check the attached sanple spreadsheet containing a blank chart along with following piece of .NET (C#) code to fill the chart with constant values as per your original post.
C#
Workbook workbook = new Workbook(Path.Combine(dir, “template.xlsx”));
Worksheet worksheet = workbook.Worksheets[0];
Chart chart = worksheet.Charts[0];
chart.NSeries.Clear();
string data = “{54,89,34,45}”;
chart.NSeries.Add(data, false);
string category = “{2002,2003,2004,2005}”;
chart.NSeries.CategoryData = category;
workbook.Save(Path.Combine(dir, “output.xlsx”));
Please let me know if I have understood your question correctly and/or you need the sample code in any other language.