Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I generate a chart using ExcelWriter?

April 26, 2017chart excelwriter

0

Posted

Can I generate a chart using ExcelWriter?

1 Answer

0

Posted

Yes. Use the method Charts.Add to generate a chart. ExcelWriter can generate 15 chart types and over 70 sub-types (see Chart Codes). ExcelWriter’s numerous charting properties allow you to customize every detail of your chart. • What versions of Microsoft Excel does ExcelWriter support? ExcelWriter can produce either Excel 97/2000/2002/2003 (BIFF8) format files or Excel 95 (BIFF7) format files. Not all features are supported by Excel 95. Note: The ExcelTemplate object supports Excel’s BIFF8 (Excel 97/2000/2002/2003) format only; ExcelTemplate does not support BIFF7 (Excel 95) format templates, and will not generate BIFF7 format files. • Which Microsoft Excel features are not available in ExcelWriter? We are constantly adding new features to ExcelWriter. If there is a particular Microsoft Excel feature currently unavailable in ExcelWriter that you would like to use, please let us know by sending an email to info@softartisans.com. • The ExcelApplication object and the ExcelTemplate canno