Displaying chart data as numerical rather than percentage values

Hello,

I am using the $tbs->plugin(OPENTBS_CHART... function to generate charts. It's working well but it appears to render the numerical data keys as a percentage rather than a straight numerical which is what I need. Can I configure it to render straight numerical values as opposed to percentages? I can't seem to find a reference to it in the docks.

Also can you dynamically change the title of a chart whilst using the chart title as a reference to edit the chart?

Thanks

Correction.

re the title. Basically what I'm asking is how do I dynamically change the display title of each chart?

Hello,

The command OPENTBS_CHART can only modify series, and not the tile in a chart.

There is a hard solution for modifying the title of a chart: open the sub-file corresponding to the chart, and do a str_replace() on $TBS->Source.

The command OPENTBS_CHART_INFO can help you to find the sub-file corresponding to the chart.

Thanks for that. i will try.

I have outputted OPENTBS_CHART_INFO. I get an array of values relating to the chart. I'm not sure what you mean by 'sub-file'. Do you mean the embedded excel files associated with each chart? If so how would I access it? what path would I have to use to get to the file etc? Not clear what you mean? thanks.

Hi,

A sub-file is and XML file stored in the document.
You can load it using command OPENTBS_SELECT_FILE.
Then you can read and edit the content using $TBS->Source.

So I run the following code:

$subFile = 'word/embeddings/Microsoft_Excel_Worksheet3.xlsx';
$TBS->PlugIn(OPENTBS_SELECT_FILE, $subFile);
str_replace('$CLIENT_NAME$', 'Test String', $TBS->Source);
$TBS->LoadTemplate(false);

'$CLIENT_NAME$' is still there as the chart title. Am I doing it correctly? I have tried unzipping the docx file first. I'm obviously targeting the Microsoft_Excel_Worksheet3.xlsx file which contains the data for the chart I am targeting.

Am I missing something?

Thanks