使用OpenTBS示例Scatter Excel Chart

Question

Can anybody give me an example of how to create an Excel Scatter chart using OpenTBS/TinyButStrong? And are there any commercial/non-commercial PHP excel writers that support excel charts?

Will really appreciate your help.

Thank you for your time!

Answer 1

Create a basic XY chart using the wizard in Ms Word. Save the chart without changing it. Let the values and the design. Select the chart, and in the contextual menu, chose "Format of the zone" or something like this. In the "Alt Text" tab, in zone "Title", enter "a nice chart". Save the template.

At the PHP side:

$template = 'demo_ms_word.docx'; $TBS->LoadTemplate($template);

$ChartNameOrNum = 'a nice chart'; // Title of the shape that embeds the chart
$SeriesNameOrNum = 1;
$NewValues = array( array( 1.5, 2.0, 3.2, 33), array(1.77, 2.88, 2.88, 2.99) );
$NewLegend = "OpenTBS is so strong";
$TBS->PlugIn(OPENTBS_CHART, $ChartNameOrNum, $SeriesNameOrNum, $NewValues, $NewLegend);

$TBS->Show(OPENTBS_FILE+TBS_EXIT, 'result.docx');

After it works, change the chart properties and the data.