CODEWITHSUNDEEP
phpexcelchartsxls
Will Bonde
Will Bonde

Reputation: 538

Are there formulas in Excel to create charts without using the ChartWizard?

I'm using a neat JQuery plugin called JQuery.sheet to do some simple web spreadsheets with charts. It has some chart formulas like "=BARCHART(A1:A10)", for example, to render a chart. Does Microsoft Excel have something similar? It would be nice for exporting spreadsheets with charts from PHP, without having to use external libraries.

Thanks in advance!

Upvotes: 0

Views: 150

Answers (1)

Marc B
Marc B

Reputation: 360782

You can do it via VB: http://support.microsoft.com/kb/213352

This'd mean using something PHPExcel to embed VB in a spreadsheet you're creating. Embedding languages in languages to accomplish something is always such fun...

Upvotes: 1

Related Questions