By: George
Date: 2013-12-19
Time: 15:08
|
Chart with datesDear friends
I had a problems with charts when I tried to add data in the form of date. I would like to contribute by sharing the solution to the community and if you want it would be useful to add it to the documentation :
|
|
By: Skrol29
Date: 2013-12-20
Time: 01:23
|
Re: Chart with datesHi George,
Thanks for this tip. Can you explain how you convert dates to numbers in Excel ? |
|
By: George
Date: 2013-12-20
Time: 08:25
|
Re: Chart with datesHi Skrol29,
For example if you have a date in an excel cell (e.g. 2/3/2014) and you want to create a chart. You have to convert it to number by doing right click->Format cells->Number and the cell will be converted into something like 41700. This is the correct for a diagram. If you put 2/3/2014 it does not work |
|
By: Skrol29
Date: 2013-12-20
Time: 17:05
|
Re: Chart with datesDo you mean date must be converted in the template, or at the PHP side when using $TBS->PlugIn(OPENTBS_CHART, ...) ?
|
|
By: George
Date: 2013-12-20
Time: 17:23
|
Re: Chart with datesThe template can have a chart drawn. And if you want to use data in the form of date there you can. But if you try to change the data displayed via php you will not be able to do it UNLESS you make the conversion to number. I did this conversion in excel but I believe that somehow this could also be done through php.
|
|
By: George
Date: 2013-12-22
Time: 16:51
|
Re: Chart with datesMicrosoft says that :
Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900 Consequently if you want to make the conversion to number through php you can write a function which calculates the days after 1/1/1990 |
|
By: Skrol29
Date: 2013-12-23
Time: 16:22
|
Re: Chart with datesHi George,
OpenTBS actually does such a conversion when you merge a date value into a cell that has "ope=tbs:date". So it has to be able to do the same in charts ... |
|
By: George
Date: 2014-01-02
Time: 22:44
|
Re: Chart with datesHi Skrol29
If I understand well in order to use this functionality you have to write sth like this command in word ([ope=tbs:date]). If you want to keep word clear? (I have 150 dates..). I need to change the value of the chart internally with PHP , can I do it with opentbs? Personally I would calculate the days with sth like this http://www.php.net/mktime but if there is embeded functionality even better. Thanks PS I like your scripts here www.skrol29.com :) |